mysql迁移至8.0时的注意事项(小结)

`mysql_native_password`：7.0 以下
`caching_sha2_password`：8.0 以上

[mysqld]
default_authentication_plugin=mysql_native_password

# 创建新的账号
create user 'root'@'%' identified with mysql_native_password by '123456';

# 已存在的账号
alter user 'root'@'%' identified with mysql_native_password by '123456';

# 授权也不能兼并创建账号了，只能授权
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

set global validate_password.policy=0;
set global validate_password.length=6;

# Default Homebrew MySQL server config
[client]
default_character_set=utf8mb4

[mysql]
default_character_set=utf8mb4

[mysqld]
default_authentication_plugin=mysql_native_password
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci

[mysqld]
#bind_address=127.0.0.1

update mysql.user set host='%' where user='root';