Re: Locked myself out of MySQL

[nux@xxxxxx]

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

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos