How to connect external MySQL in docker

In Docker, the method to connect MySQL to an external database is as follows: Create a network to connect to containers. Start the MySQL container and specify the network name. Grant external access to allow connections. Connect to an external database using a connection string.

How to connect MySQL in Docker to an external database

When running MySQL in a Docker container, you may need to connect to an external database to enable data sharing or access to an external data source. Here is how to connect MySQL in Docker to an external database:

1. Create a network

Docker containers are in different network spaces by default, so networks need to be created so that containers can communicate. You can create a network using the following command:

 <code>docker network create my-network</code>

2. Start the MySQL container

Before connecting to an external database, you need to start the MySQL container. The following command creates and starts the MySQL container, specifying the network name and exposing port:

 <code>docker run -d \ --name mysql \ --network my-network \ -p 3306:3306 \ mysql:5.7</code>

3. Grant external access rights

By default, MySQL containers only allow local connections. External access is required to allow other containers or hosts to connect. Grant permissions using the following command:

 <code>docker exec mysql mysql -uroot -p <your-password></your-password></code>

At the command prompt:

 <code>GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;</code>

in:

• username is the name of an external user
• password is the password of an external user
• % Allow connections from any host

4. Connect to external database

Use an external application or tool to connect to an external database. The following connection string can be used:

 <code>mysql -h <external_host> -u <username> -p <password> <database_name></database_name></password></username></external_host></code>

in:

• <external_host></external_host> is the host name or IP address of the external database
• <username></username> is the user name that grants external access permissions
• <password></password> is the password that grants external access permissions
• <database_name></database_name> is the name of the database to be connected to.

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