Mysql找回丢失密码

时间:2023-03-09 20:17:05
Mysql找回丢失密码

(先进入root权限):
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root
mysql> update mysql.user set password=password("newpassword") where user='root' and host="localhost";
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
enter password: <输入新设的密码newpassword>