[CentOS] Locked myself out of MySQL

Sat Mar 26 21:00:21 UTC 2011
Todd Cary <todd at aristesoftware.com>

On 3/26/2011 1:33 PM, nux at 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 at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>
Wish my memory was close to yours!  Thanks!  Need to look up 
mysqld_safe.

Todd

-- 
Ariste Software
Petaluma, CA 94952

http://www.aristesoftware.com