How to configure docker running mysql

Configuring MySQL in Docker involves the following steps: Create a Docker image based on the official MySQL image. Start the container and specify the MySQL root password, database name, and port mapping. Use the docker exec command to connect to the container and configure it using the MySQL command line interface.

Configuration for running MySQL in Docker

How to configure MySQL in Docker?

Configuring MySQL in Docker involves three key steps:

1. Create a Docker image

Create a Docker image based on the official MySQL image. You need to specify the required version of MySQL, for example:

 <code>docker build -t my-mysql-image .</code>

2. Start and configure the container

Start a Docker container with the created image and specify the necessary configuration:

 <code>docker run -d --name my-mysql-container \ -e MYSQL_ROOT_PASSWORD=your_password \ -e MYSQL_DATABASE=your_database \ -p 3306:3306 \ my-mysql-image</code>

in:

• -e MYSQL_ROOT_PASSWORD Sets the password of the MySQL root user.
• -e MYSQL_DATABASE Create a database named your_database .
• -p 3306:3306 Map the MySQL port in the container to the 3306 port on the host.

3. Connect to the container

Use the docker exec command to connect to the container and configure it using the MySQL command line interface:

 <code>docker exec -it my-mysql-container bash mysql -u root -p</code>

Detailed description:

• Environment variables: You can specify environment variables when starting the Docker container to configure the MySQL server, such as the root password and the name of the desired database.
• Port Mapping: You can use the -p flag to map the ports inside the container to the ports on the host, which will allow you to access MySQL from the host.
• MySQL command line interface: Once connected to a container, you can use the MySQL command line interface for further configuration, such as creating users, granting permissions, and querying data.

By following these steps, you can successfully configure and run MySQL in Docker.

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