安装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;//刷新权限