虚拟机上安装的mysql8.0.11,用客户端Navicat连接时,报错-1251-client does not support authentication protocol request by server ;consider upgrading MySQL client。
原因是mysql8.x修改了身份验证的插件,由以前的默认身份验证插件mysql_native_password变成了-caching_sha2_password。
按照官网的改法,我们可以修改一下格式。
ALTER USER 'root'@'localhost'
IDENTIFIED WITH mysql_native_password
BY 'password';
alter user 'root'@'%' identified with mysql_native_password by'******';
然后再连接就可以成功了。