[mythtv-users] Goofed up root password for MySQL

[Jeff Mottishaw]

http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html  should answer
your question

(was found by googling for: reset root password mysql)

You may want to check to see if the password is "ROOT_PWD" I'm not anything
near a mysql expert but that looks like what you've set the password to.

jeff

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of bmcdevitt
Sent: May 14, 2004 2: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