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 -- Ariste Software Petaluma, CA 94952 http://www.aristesoftware.com
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 Sat, 26 Mar 2011 13:24:40 -0700 Todd Cary <todd at 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. -- Jure Pe?ar http://jure.pecar.org http://f5j.eu
At Sat, 26 Mar 2011 13:24:40 -0700 CentOS mailing list <centos at 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 >-- Robert Heller -- 978-544-6933 / heller at deepsoft.com Deepwoods Software -- http://www.deepsoft.com/ () ascii ribbon campaign -- against html e-mail /\ www.asciiribbon.org -- against proprietary attachments