上篇刚写了安装Mysql,想用Navicat去连接,然后就报错了,此处记录报错解决。
报错:Client does not support authentication protocol requested by server; consider upgrading MySQL client
第一步在命令行输入
mysql -uroot -p
第二步
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.10 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
即可重新登录。