docker安装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;