查询当前插件加密方式
select host,user,plugin,authentication_string from mysql.user;
把caching_sha2_password 改成 mysql_native_password
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';
查询当前插件加密方式
select host,user,plugin,authentication_string from mysql.user;
把caching_sha2_password 改成 mysql_native_password
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';