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;

 

posted @ 2025-04-29 11:11  akgang  阅读(858)  评论(0)    收藏  举报