Mysql8安装问题
CMD下利用mysql -uroot -p 登录时,密码正确切设置允许远程,仍报错
ERROR 1045(280000):Access denied for user 'root'@'XXXXXXX'
可能是caching_sha2_password plugin造成的。
此时可以尝试用SQLyog连接测,如果试报plugin caching_sha2_password could not be loaded,可利用如下方法修复:
-
alter user 'root'@'localhost' identified by '123456' password expire never;
-
alter user 'root'@'localhost' identified with mysql_native_password BY '123456';
-
flush privileges ; #########重要,刷新一下权限###############