1251-Client does not support authentication protocol requested by server

1、错误描述

1251-Client does not support authentication protocol requested by server
使用Navicat连接MySQL8.0

 

2、错误原因

      使用MySQL客户端Navicat连接数据库MySQL8.0,MySQL8.0 之前的版本中加密规则是mysql_native_password,而MySQL8.0,加密规则是caching_sha2_password

3、解决办法

(1)将加密规则还原成mysql_native_password

         a、通过开始菜单,找到MySQL文件

1251-Client does not support authentication protocol requested by server
使用Navicat连接MySQL8.0

        b、通过文件属性找到安装目录

1251-Client does not support authentication protocol requested by server
使用Navicat连接MySQL8.0

     c、进入安装目录,复制路径

1251-Client does not support authentication protocol requested by server
使用Navicat连接MySQL8.0

     d、依次执行以下命令

1251-Client does not support authentication protocol requested by server
使用Navicat连接MySQL8.0

     e、验证是否可连

1251-Client does not support authentication protocol requested by server
使用Navicat连接MySQL8.0