1、Navicat 连接 mysql 80 提示Client does not support authentication protocol requested by serverMysql 80用户可能会遇到以下两个问题这两个问题navicatclientdoesnotsupport的本质就是解决方案很简单navicatclientdoesnotsupport,就是更新加密方式为 mysql_native_password 就OKnavicatclientdoesnotsupport了请额外注意navicatclientdoesnotsupport,部分情况下 root 可能不在 localhost 。
2、databasename lt path\*sql create database name character set utf8如果出现#1251 Client does not support authentication protocol requested by servernavicatclientdoesnotsupport的错误解决办法先用root登录MYSQL服务器,执行 mysqlset password for user1@quotlocalhostquot=old_password#39yourPassword#39。