How to start mysql by docker

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port to verify the connection Create the database and the user grants all permissions to the database

How to start MySQL in Docker

Starting MySQL in Docker is a relatively simple process that provides a convenient way to run MySQL in an isolated and portable environment.

step:

1. Pull MySQL image:

    <code>docker pull mysql</code>

2. Create and start the container:

    <code>docker run -d --name mysql -e MYSQL_ROOT_PASSWORD=your_password -p 3306:3306 mysql</code>

   in:

   • -d flag runs container in daemon mode
   • --name mysql specifies a name for the container
   • -e MYSQL_ROOT_PASSWORD=your_password Set the password of the MySQL root user
   • -p 3306:3306 Map port 3306 in the container to port 3306 of the host

3. Verify the connection:
   After waiting for the container to start, you can verify the connection using the following command:

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

4. Create databases and users:
   After connecting to MySQL, you can create a database and user using the following command:

    <code>CREATE DATABASE your_database; CREATE USER 'your_username'@'%' IDENTIFIED BY 'your_password';</code>

5. Grant permissions:
   Finally, grant new users all permissions to the new database:

    <code>GRANT ALL PRIVILEGES ON your_database.* TO 'your_username'@'%';</code>

Now, you have successfully started and configured MySQL in Docker.

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