Docker创建的MySQL 容器

容器来源：https://hub.docker.com/_/mysql/tags
版本自选

 docker pull mysql:5.7.39

容器配置

docker run \
--name mysql5.7.39 \
-d \
-p 3306:3306 \
--restart unless-stopped \
-v /share/CACHEDEV2_DATA/log:/var/log \
-v /share/CACHEDEV2_DATA/var/lib/mysql:/var/lib/mysql \
-v /share/CACHEDEV2_DATA/etc/my.cnf:/etc/my.cnf \
-e MYSQL_ROOT_PASSWORD=msyql123123 \
mysql:5.7.39

登录MySQL

 mysql -uroot -pmsyql123123

创建用户

CREATE USER 'qusay'@'172.16.2.3' IDENTIFIED BY 'mysqldlmm00';
grant all privileges on *.* to 'qusay'@'172.16.2.3'; 

修改MySQL5.7默认字符集为utf8

[mysqld]
character-set-server=utf8mb4

其他问题
映射的配置文件my.cnf无法生效——权限问题