Docker Connect To Localhost Install It Using

Docker Connect To Localhost Install It Using

I also assume that you have set up your virtual environment for this project, so its easier for you to control dependencies and packages. 1. Installing sqlalchemy library If you have not installed this library on your environment, install it using pip from your Terminal as follows.

And so, I thought to write this guide to help people save their time from trying to figure out how to do it.

In this article, I am going to walk you through the process end-to-end, from installing mysql docker all the way to writing Python script to connect to it.

Installing mysql Docker This guide assumes you have already installed Docker on your MacBook and all the steps below are to be executed from your Terminal application.

I personally use iTerm2.

MacBook-Pro: username docker pull mysql:latest You actually do not need to follow this step and can skip straight to step 2.

But for me, I like to break it down so you know what is exactly going on.

After completing this step, all that has been done is storing a docker image of mysql on your local MacBook so you can build a docker container out of it.

Running the mysql docker You can check if you have pulled the right image by executing docker image ls from your terminal.

If the docker pull was successful, you should see something like this.

REPOSITORY TAG IMAGE ID CREATED SIZE mysql latest 91dadee7afee 2 weeks ago 477MB Then, you can start the docker container by running the following.

As mentioned in step 1, you can actually jump straight to below command.

It will automatically do docker pull to pull the mysql image) MacBook-Pro: username docker run --nameusermysql1 --envMYSQLROOTPASSWORDrootpassword -p 3306:3306 -d mysql:latest Let me explain the parameters in the command above: --name: this is optional.

It specifies the name of the running docker container --env: this is required, otherwise you would see the following error.

As from the error message, you can choose to specify any of the MYSQLROOTPASSWORD, MYSQLALLOWEMPTYPASSWORD and MYSQLRANDOMROOTPASSWORD.

One thing to note is if you already have a running mysql, you would need to either specify a different port for the outside world or terminate the running mysql.

The format of this parameter is as follows hostPort:containerPort.

Check if the docker is running properly After the step 2 runs successfully, you can do docker ps to check if the mysql docker is running.

Awesome, now you have a running mysql docker on your MacBook.

Congratulations Next, I will show you how to do a basic setup on the mysql inside the container so you can start connecting to it from your Python application.

Set Up mysql Inside Docker The following steps will still be executed from your Terminal application.

Access mysql from terminal To access mysql inside your docker container, do the following.

MacBook-Pro: username docker exec -it usermysql1 mysql -uroot -prootpassword Notice the root s password is what is specified in the previous step 2 docker run above.

Create a table inside the new database Here, we will create a table so we can test our Python application later.

Create a new user After the database has been created, lets create a user to interact with that database.

As best practice, we should never use the root user to do our work.

We should only use root user if we really have to, e.g.

Lets create a new user named newuser with password newpassword.

This is to allow remote connection from anywhere via user newuser.

Awesome. Now, you have already set everything up and we are ready to move on to our Python application.

Write Python Script to Connect to mysql Docker For this guide, I am going to use sqlalchemy library to connect to mysql inside the docker container.

I also assume that you have set up your virtual environment for this project, so its easier for you to control dependencies and packages.

Installing sqlalchemy library If you have not installed this library on your environment, install it using pip from your Terminal as follows.

Docker For Mac Connect To Localhost