zxbking/mysql8 repository overview

将mysql:8.0.16而外保存一份 启动脚本 docker run -di --name=mysql8
-v /home/docker/mysql8/data:/var/lib/mysql
-v /home/docker/mysql8/conf/my.cnf:/etc/mysql/my.cnf
--privileged=true
-p 3308:3306
-e MYSQL_ROOT_PASSWORD=123456 zxbking/mysql8
--lower_case_table_names=1

删除my.cnf文件夹，重新创建该文件，内容如下 [client] default-character-set=utf8mb4

[mysql] default-character-set=utf8mb4

[mysqld] pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock datadir = /var/lib/mysql secure-file-priv= NULL #Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 max_connections=10000 default-time_zone='+8:00' character-set-client-handshake=FALSE character_set_server=utf8mb4 collation-server=utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci' #Custom config should go here !includedir /etc/mysql/conf.d/

启动后执行mysql ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'zxb2018.';

flush privileges;

重启docker 容器