[CentOS] Locked myself out of MySQL

nux at li.nux.ro nux at li.nux.ro
Sat Mar 26 20:33:32 UTC 2011

Todd Cary writes:

> Darn!  I must have either made a typo or my use of a ";" in the 
> MySQL root password so now I am locked out.
> Is there a work around or do I have to uninstall MySQL and reinstall?
service mysqld stop
mysqld_safe --user=mysql --skip-grant-tables &
mysql -u root
update mysql.user set password=password("blahcopter") where user="root";
flush privileges;
service mysqld restart

Written from (very volatile) memory so double check the commands..


More information about the CentOS mailing list