远程连接 MySQL Community Server 8.0.13时可能报错Authentication plugin ‘caching_sha2_password’ cannot be loaded,解决方法是在运行mysql的机器中进入mysql命令行,执行
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新密码';
如果报错 mysql_native_password plugin not loaded,则执行
ALTER USER 'root'@'%' IDENTIFIED BY '新密码';
然后再执行
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新密码';
反复直到此命令无报错,即可远程连入MySQL。
8.0.13 MySQL Community Server远程连接故障处理
最新推荐文章于 2021-02-02 02:42:51 发布