升级MySQL 8之后 连接不上数据库

#配置my.cnf 使用老的验证方式

[mysqld]

default_authentication_plugin = mysql_native_password

character-set-server = utf8

 

#修改基于老认证的账户密码

ALTER USER 'user'@'%' IDENTIFIED WITH mysql_native_password BY 'pass';

select host, user, authentication_string, plugin from user;