Docker installs mysql and solves the Chinese garbled problem

1. Pull the mysql image

Website: https://hub.docker.com/

Copy the command to download: docker pull mysql[:版本號]
Without version number, the latest version is used by default

2. Check whether the download is complete

docker images 

3. MySQL mounts local directory & solves Chinese garbled characters

Because there is no vi command in the container, we can mount數據and配置on the host machine to facilitate our operation.

Create folders separately

/tmp/mysql/data
/tmp/mysql/conf
Create the hmy.cnf file in the conf folder and copy the following content into it
Solve the problem of Chinese garbled characters, so that Chinese characters will not be garbled when you search

[mysqld] 
skip-name-resolve
character_set_server=utf8
datadir=/var/lib/mysql
server-id=1000
[mysql] 
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[client]
default-character-set = utf8

4. Create a container and view it

Create command:

docker run \
 --name mysql \
 -p 3306:3306 \
 --privileged=true -v /tmp/mysql/data:/var/lib/mysql \
 -v /tmp/mysql/conf/hmy.cnf:/etc/mysql/conf.d/hmy.cnf \
 -e MYSQL_ROOT_PASSWORD=123456 \
 -d \
 mysql:latest

Check whether the creation is successful:

docker ps -a 

If you accidentally create an error, you can delete docker rm -f 創建的名字

Enter the mysql container: docker exec -it mysql bash

Use Navicat to test whether it is started

Test whether Chinese characters are garbled

This is the end of this article about the detailed tutorial on how to install MySQL on Docker and solve the problem of Chinese garbled characters that I have tested myself. For more related content, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!