[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;
exit;
service mysqld restart
Written from (very volatile) memory so double check the commands..
--
Nux!
www.nux.ro
More information about the CentOS
mailing list