重置Mysql的root密码

March 26, 2012 帮助FAQ YY.K Permalink 
1
2
3
4
5
6
7

service mysql restart  --skip-grant-tables
mysql -u root -ppwd <<EOF
use mysql
update user set password=password("新密码") where user="root";
flush privileges;
EOF
service mysql restart
mysql, 密码, 重置