MySQL8忘记root密码处理步骤
2023-04-09 本文已影响0人
Quick_5413
1、systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
2、systemctl restart mysqld
3、输入mysql后可直接登录
4、mysql> alter user 'root'@'localhost' identified by 'xxxxxxx';
mysql>flush privileges;
mysql> alter user 'root'@'localhost' identified by 'xxxxx';
退出登录
5、恢复密码登录
systemctl set-environment MYSQLD_OPTS=""
systemctl restart mysqld
或者
reboot
systemctl show-environment 查看MYSQLD_OPTS
分享：
