远程连接mysql数据库时,报错
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded
解决方法如下:
mysql -u root -p
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'new_password';
即,修改一次密码就可以了
远程连接mysql数据库时,报错
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded
解决方法如下:
mysql -u root -p
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'new_password';
即,修改一次密码就可以了