[CentOS] Locked myself out of MySQL
nux at li.nux.ro
nux at li.nux.roSat Mar 26 20:33:32 UTC 2011
- Previous message: [CentOS] Locked myself out of MySQL
- Next message: [CentOS] Locked myself out of MySQL
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [CentOS] Locked myself out of MySQL
- Next message: [CentOS] Locked myself out of MySQL
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the CentOS mailing list