Resetting a lost MySQL root password

2014年8月05日 20:10

Stop MySQL

Safe mode

mysqld_safe --skip-grant-tables &

Login

mysql -u root
use mysql;

Reset Password

update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges;