[mythtv-users] Goofed up root password for mySQL...

[bmcdevitt]

Never mind, figured it out.

Link to HOWTO for future reference:

http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html

Bill

---- Original Message ----
From: bmcdevitt at cox.net
To: mythtv-users at mythtv.org
Subject: RE: [mythtv-users] Goofed up root password for mySQL...
Date: Fri, 14 May 2004 14:04:34 -0700

>Greetings!
>
>Working through Jarod's install, and at Step 13 Set up MySQL, I had a
>cut and paste error to the console.
>
>I ran this command:
>
># mysql -u root mysql
>
>got the mysql prompt.  Cut and pasted this command into the console,
>but when I pasted I had grabbed part of the next line too (mysql>
>FLUSH):
>
>mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE
>user='root';
>
>Apparently the part of the next line set the password...
>
>Not thinking anything bad had happened, I ran the next two commands:
>
>mysql> FLUSH PRIVILEGES;
>mysql> quit 
>
>Now I cannot log into mysql as root, as it tells me the root password
>is bad.  I've tried all sorts of combinations of the real root
>password, no password, and the part of the line that got added in by
>accident.
>
>Is there any way to clear the root password and reset it or am I
>going to have to go the reinstall route?
>
>Thanks for your time.
>
>Regards, Bill