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?
Todd
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
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
On Sat, 26 Mar 2011 13:24:40 -0700 Todd Cary todd@aristesoftware.com wrote:
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?
--skip-grant-tables
Check mysql docs next time.
On 3/26/2011 1:36 PM, Jure Pečar wrote:
On Sat, 26 Mar 2011 13:24:40 -0700 Todd Carytodd@aristesoftware.com wrote:
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?
--skip-grant-tables
Check mysql docs next time.
I did use the MySQL 5 manual and the forum, but like so many details in the computer world, unless I know what to search for, it is hard to get the correct answer. The key here is mysqld_safe.
Really sorry to have taken everyone's time...especially for such simple stuff.
Todd
At Sat, 26 Mar 2011 13:24:40 -0700 CentOS mailing list centos@centos.org wrote:
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?
Is the data in the database expendable (or is the database empty)?
Do you have a database backup?
If either of the above, you can probably just do a rm on the MySQL database (after *stopping* the MySQL daemon!) and have MySQL create a fresh, empty database using the MySQL first time install script. And then set the password properly and/or restore the backup (if necessary you can edit the backup file if the password there is 'bad').
Todd