Mysql 和Navicat for MySql互联的时候出现如下错误:
1251-Client does not support authentication protocol requested by server;consider upgrading MySQL cl
出现这个主要是因为两个软件之间的版本之间存在的差距
可以解决这个问题的的措施之一是:
1.create user 'sunhao'@'%’identified by '123456';
2.grant all on *.* to 'sunhao'@' %' with grant option;
3.alter user 'sunhao'@'%’ identified with mysql_native password by '123456';
4.select user, host, plugin from mysql.user ;
新创建的用户的的密码方式变为:
即可