MYSQL 2059 Navicate无法连接

安装 了mysql8后出现2059错误。

原因为安装时选择了强加密规则caching_sha2_password，与之前的mysql5.7的mysql_native_password规则不同，navicate驱动目前不支持新加密规则。

我们需要更改加密规则

就像图中一样

1. 进入MySQL

   mysql -u root -p
   

2. 查看加密规则

   use mysql;
   
   select user,plugin from user where user='root';
   +------+-----------------------+
   | user | plugin                |
   +------+-----------------------+
   | root | caching_sha2_password |
   +------+-----------------------+
   1 row in set (0.00 sec)
   

3. 修改加密规则

   ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
   

4. 刷新权限

   flush privileges;
   

5. 查看规则

   select user,plugin from user where user='root';
   +------+-----------------------+
   | user | plugin                |
   +------+-----------------------+
   | root | mysql_native_password |
   +------+-----------------------+
   1 row in set (0.00 sec)
   

6. 然后测试连接