![MYSQL错误码2059解决办法[Python常见问题]](https://www.zixueka.com/wp-content/uploads/2023/10/1696830947-e982461879bc2c8.jpg)
第一步:登入
mysql -u root -p
第二步:查看加密规程
select user,plugin from user where user="root";
结果显示
+------+-----------------------+
| user | plugin |
+------+-----------------------+
| root | caching_sha2_password |
+------+-----------------------+
第三步:修改加密规则
ALTER USER "root"@"localhost" IDENTIFIED BY "password" PASSWORD EXPIRE NEVER;
第四步:重修修改密码
ALTER USER "root"@"localhost" IDENTIFIED WITH mysql_native_password BY "131556";
第五步:刷新
FLUSH PRIVILEGES;
hmoban主题是根据ripro二开的主题,极致后台体验,无插件,集成会员系统
自学咖网 »
MYSQL错误码2059解决办法