MySQL 5.7升级到MySQL 8.0

将 docker 中运行的 MySQL 5.7 升级到 MySQL 8.0

关闭容器

copy 整个目录

更新镜像为mysql:8.0

等待mysql自动升级数据库

[System] [MY-013381] [Server] Server upgrade from ‘50700’ to ‘80037’ started.

[System] [MY-013381] [Server] Server upgrade from ‘50700’ to ‘80037’ completed.

进入镜像，登录mysql

use mysql;

select user, plugin from user;

查看用户密码加密类型

将mysql_native_password类型的更新为caching_sha2_password(待会更新到8.4后默认就禁用mysql_native_password加密了)

ALTER USER ‘root’@’localhost’ IDENTIFIED WITH ‘caching_sha2_password’ BY ‘************’;

弱密码会提示不符合安全规范，要么自己改一下密码规则，要么用大写字母+小写字母+数字+符号的密码吧

重启，搞定！