Installing MySQL with Docker

Aug 10, 2024#docker #mysql70

AI Translation

This post is translated from Chinese into English through AI.View Original

AI-generated summary

To install MySQL using Docker, you can pull the latest MySQL image with the command `docker pull mysql`. For a specific version, like 6.0, use `docker pull mysql:6.0`. To run MySQL and map it to port 3306, use the following command, replacing `jiamian` with your Linux username and setting your desired MySQL root password: ```bash docker run -d -p 3306:3306 --privileged=true -v /jiamian/mysql/log:/var/log/mysql -v /jiamian/mysql/data:/var/lib/mysql -v /jiamian/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql-1 mysql ``` This setup prevents data loss after deleting the MySQL container, as you can recover data by rerunning the command. To check if MySQL is running, use `docker ps`. To resolve Chinese character encoding issues, navigate to the MySQL configuration directory and create a `my.cnf` file with the following content: ``` [client] default_character_set=utf8 [mysqld] collation_server = utf8_general_ci character_set_server = utf8 ``` After saving the file, restart MySQL with `docker restart mysql-1`. You can then access the MySQL environment using `docker exec -it mysql-1 /bin/bash`, where Chinese characters should display correctly.

docker pull mysql # Pull the mysql image (latest version)

If you want to install a specific version like 6.0, the command is as follows:

docker pull mysql:6.0

Run mysql and allocate port 3306, the command is as follows: (Note: the following is a single command)

In this command, jiamian is the username of the author's Linux system, replace it with your own username when using.

After MYSQL_ROOT_PASSWORD, fill in the mysql password, which can be replaced as needed.

The name mysql-1 after --name is the name of the running mysql container, which can also be replaced as needed.

docker run -d -p 3306:3306 --privileged=true -v /jiamian/mysql/log:/var/log/mysql

-v /jiamian/mysql/data:/var/lib/mysql -v /jiamian/mysql/conf:/etc/mysql/conf.d

-e MYSQL_ROOT_PASSWORD=123456 --name mysql-1 mysql

This command can also solve the problem of database data loss that occurs after deleting the mysql container. To recover the data, simply rerun the command.

Run the docker ps command to see that mysql is running.

Solve the issue of Chinese characters being garbled when inserting into mysql#

Then enter the command cd /jiamian/mysql/conf. After entering this directory, input the command vim my.cnf to create a new my.cnf file,

and enter the following code:

[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8

After saving and exiting, enter docker restart mysql-1 to restart mysql.

Then enter docker exec -it mysql-1 /bin/bash to enter the mysql environment, at this point Chinese characters can be displayed normally.