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;
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges;