Re: [CentOS] Locked myself out of MySQL

On 3/26/2011 1:33 PM, nux@nux.ro wrote:

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@centos.org http://lists.centos.org/mailman/listinfo/centos

Wish my memory was close to yours! Thanks! Need to look up mysqld_safe.

Todd