当前位置：网站首页>Part 3: docker installing MySQL container (custom port)

Part 3: docker installing MySQL container (custom port)

2022-04-23 13:21:00 【Da Linzi xiansen】

First step ： Download mirroring

docker pull mysql:5.7

The second step ： Create an instance and start

docker run -p 3306:3306 --name mysql \ -v /mydata/mysql/log:/var/log/mysql \ -v /mydata/mysql/data:/var/lib/mysql \ -v /mydata/mysql/conf:/etc/mysql \ -e MYSQL_ROOT_PASSWORD=root \ -d mysql:5.7

The third step ： Get into mysql The command line interface of the container

docker exec -it mysql /bin/bash

Step four ： Sign in mysql

mysql -u root -p

Step five ： To configure

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake
skip-name-resolve

Step six ： Set boot up mysql