[mythtv-users] Goofed up root password for MySQL

[Tyler Drake]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try (without quotes) "ROOT_PWD".  Yes, it does need to be I all caps.
 I am assuming you didn't modify the line, and pasted exactly as you
show?

- --Tyler

>-----Original Message-----
>From: mythtv-users-bounces at mythtv.org 
>[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of bmcdevitt
>Sent: Friday, May 14, 2004 5:14 PM
>To: mythtv-users at mythtv.org
>Subject: [mythtv-users] Goofed up root password for MySQL
>
>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
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0.3

iQA/AwUBQKU9Sjpg2SqUw6KTEQKIAgCZAZnYouz0ASUDV5U39dyqQI4ngGcAoPW/
Q69IjJGe8Frzx0PEelnvCKE4
=UQPj
-----END PGP SIGNATURE-----