docker安装mysql:8.0

镜像

docker pull mysql:8.0

首次运行

docker stop mysql_3333
docker rm  mysql_3333
docker run  -d  -p 3333:3306 --name mysql_3333 -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0  

复制mysql配置文件

docker cp mysql_3333:/var/lib/mysql /data/mysql8/mysqldata/
docker cp mysql_3333:/etc/my.cnf  /data/mysql8/etc/

启动

vim start_mysql8_0.sh 
docker stop mysql_3333
docker rm  mysql_3333

docker run \
 --name  mysql_3333 \
 --privileged=true \
 --restart=always \
 -p 3333:3306 \
 -e MYSQL_ROOT_PASSWORD=123456a \
 -v  /data/mysql8/mysqldata/mysql:/var/lib/mysql   \
 -v  /data/mysql8/etc/my.cnf:/etc/my.cnf   \
 -d mysql:8.0   \
 --default_authentication_plugin=mysql_native_password

连接：

mysql -h 192.168.1.102  -uroot -p123456 -P3333 --ssl-mode=DISABLED

报错：

(1)
[root@W103 ~]# mysql -h 192.168.1.102  -uroot -p123456 -P3333
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2026 (HY000): SSL connection error: unknown error number

解决办法：
mysql -h 192.168.1.102  -uroot -p123456 -P3333 --ssl-mode=DISABLED

(2)
[root@W103 ~]# mysql -h 192.168.1.102  -uroot -p123456 -P3333 --ssl-mode=DISABLED
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
解决办法：
alter user 'root'@'%' identified with mysql_native_password by '123456';
flush privileges;

连接：
mysql -h 192.168.1.102  -uroot -p123456 -P3333 --ssl-mode=DISABLED



(3)
ERROR 1045 (28000): Access denied for user 'root'@'192.168.1.103' (using password: YES)
解决办法：
输入use mysql，修改root的密码：
alter user 'root'@'%' identified with mysql_native_password by '123456';
flush privileges;

(4)
mysql -h 192.168.1.102  -uroot -p123456 -P333
报错：
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.102' (111)
解决办法：
mysql容器内
alter user 'root'@'%' identified with mysql_native_password by '123456';
flush privileges;