完美解决ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded问题

解决方案

各种尝试,最终在stackoverflow找到解决方案,如下:

ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';

示例:

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

如果您觉得本文对您有所帮助,可以请小哥哥喝杯茶(*^▽^*)

二维码

1 views

发表评论