Re: Locked myself out of MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On 3/26/2011 1:33 PM, nux@xxxxxx 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@xxxxxxxxxx
> 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

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


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux