安装mysql8.0.17时候报错1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client

当mysql数据库安装时候选择的是加密密码时候,用navicat连接时候报错1521,这时候可以cmd之后登陆mysql执行下列代码就可以了

 

代码:

mysql> alter user root@localhost identified by 'root' password expire never;
mysql> alter user root@localhost identified with mysql_native_password by 'root' ;
mysql> flush privileges;//刷新权限

posted on 2019-08-14 09:06  songyinan  阅读(290)  评论(0编辑  收藏  举报