报错信息:
1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client
报错原因:
mysql8版本加密规则是 caching_sha2_password,而8之前版本加密规则为 mysql_native_password
解决方法:
1.升级Navicat驱动 2.修改加密规则
修改加密规则
登陆mysql:
mysql -uroot -p
修改密码规则:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
刷新权限:
flush privileges;
再次登录已经没问题了