MySQL Troubleshooting

Connecting to Mysql Service

$ mysql -hlocalhost -uroot -p123456

 

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

起因：mysql8.0加密方式的原因报错。

解决办法：

$ mysql -u root -p

123456

mysql> use mysql;

mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';

mysql> flush privileges;

注意：123456是我自己连接数据库的密码哈