[CentOS] Locked myself out of MySQL

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

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;
exit;
service mysqld restart

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

--
Nux!
www.nux.ro