接上篇,最后一步连接Navicat失败了
Navicat连接MySQL Server8.0版本
报错Client does not support authentication protocol requested by server;
解决如下:
首先进入Ctrl+E打开CMD,输入mysql.exe -hlocalhost -P3306 -uroot -p,然后输入之前设置的密码进入mysql;
mysql> use mysql
Database changed
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'root';
Query OK, 0 rows affected (0.06 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql>