How to connect mysql in docker

Connecting to the MySQL database in Docker takes only five steps: Start the MySQL container. Find the IP address of the container. Use an external client to connect to the IP address and port 3306. Enter the root password specified at startup. Specifies the database name specified at startup, if applicable.

How to connect to a MySQL database in Docker

The process of connecting to the MySQL database in Docker is simple and can be divided into the following steps:

1. Start the MySQL container

 <code class="shell">docker run -d --name my-mysql -e MYSQL_ROOT_PASSWORD=my-secret-password -e MYSQL_DATABASE=my-database mysql:latest</code>

2. Find the IP address of the MySQL container

 <code class="shell">docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' my-mysql</code>

3. Connect using an external MySQL client

On the local computer, connect to the container's IP address and port 3306 (the default port for MySQL) using your preferred MySQL client, such as MySQL Workbench or the mysql command line tool.

4. Provide credentials

Connect with the root password you specified when starting the container.

5. Specify the database

If you specified a database name when starting the container, specify that name when connecting.

Example:

Connect using the mysql command line tool:

 <code class="shell">mysql -h <mysql-container-ip> -P 3306 -u root -p <mysql-root-password></mysql-root-password></mysql-container-ip></code>

Connect using MySQL Workbench:

1. Open MySQL Workbench.
2. Click Database > Connect.

3. In the Connect dialog box, enter the following information:

   • Host:
   • Port: 3306
   • Username: root
   • Password:
   • Database: (optional)

Notice:

• Ensure that traffic on TCP 3306 ports is allowed between your host and container.
• You can use docker logs my-mysql command to view the logs of the MySQL container.
• After the container is restarted, the IP address of the MySQL container may change, so you need to rerun step 2 to get the new address.

The above is the detailed content of How to connect mysql in docker. For more information, please follow other related articles on the PHP Chinese website!