mysql版本为8.0.3
navicat版本为11.1.13不可描述版本。
在连接时显示
Client does not support authentication protocol requested by server; consider upgrading MySQL client
在网上查找资料,最终发现一个可以完美解决的方案:
mysql> use mysql;
Database changed
mysql> alter user 'root'@'localhost'identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.18 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.06 sec)
mysql>