问题:
navicat连接mysql时报错:1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方法:
通过命令行进入mysql:
1. win+R打开命令行,输入cmd,进入自己电脑mysql的安装路径;
2. 输入命令mysql -uroot -p ,键入密码,进入mysql的root账户;
3. 更改机密方式;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '自己设置的密码' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.08 sec)
4. 更改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.02 sec)
5. 刷新
mysql> FLUSH PRIVILEGES;
2 Query OK, 0 rows affected (0.01 sec)
6. 完成!!