[mythtv-users] Goofed up root password for MySQL

[bmcdevitt]

Thanks for all of your help.  As the posts crossed in the mail, I
found the answer myself, also.

Bill

---- Original Message ----
From: mythpcjabber at ec.rr.com
To: mythtv-users at mythtv.org
Subject: RE: [mythtv-users] Goofed up root password for MySQL
Date: Fri, 14 May 2004 17:42:34 -0400

> 
>-----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-----
>
>