具体问题
使用navicat110_mysql_cs_x86工具出现以下错误 :
1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client
问题原因:
出现这种情况的原因是:MySQL8 之前的版本中加密规则是mysql_native_password,而在MySQL8之后,加密规则是caching_sha2_password
解决方法:
连续执行以下命令:
1.>mysql -u root -p
2.>ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
3.>FLUSH PRIVILEGES;