[CentOS] Locked myself out of MySQL
Todd Cary
todd at aristesoftware.com
Sat Mar 26 21:00:21 UTC 2011
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
More information about the CentOS
mailing list