Mysql 8.0 连接 Navicate 密码错误问题解决方法

mysql> use mysql;

mysql> grant all PRIVILEGES on *.* to root@'%' WITH GRANT OPTION;

 
mysql> ALTER user 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;

 
mysql> ALTER user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

 
mysql>  FLUSH PRIVILEGES;

由于新版的 mysql 修改了密码的算法所以Navicate会出现密码错误的现象，修改密码算法即可