mysql9 修改密码报错:plugin 'mysql_native_password' is not loaded
原解决方案:https://github.com/Homebrew/homebrew-core/issues/180498
mysql9的密码加密方式已改变,没有了mysql_native_password,应该使用caching_sha2_password
执行以下sql:
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '新密码';
FLUSH PRIVILEGES;
邮箱:akgang@126.com
非著名程序猿-akg

浙公网安备 33010602011771号