MySQL忘记密码怎么办
停止MySQL服务
systemctl stop mysqld跳过权限启动
mysqld --user=mysql --skip-grant-tables --skip-networking &无密码登录
mysql 或者 mysql -uroot # 直接回车重置密码
FLUSH PRIVILEGES; ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码'; FLUSH PRIVILEGES; EXIT;重启
pkill mysqld # 结束跳过权限的进程 # killall mysqld systemctl start mysqld登录测试
mysql -uroot -p'新密码'