[mythtv-users] What to do when you can't remember the password for mysql
Kevin J. Cummings
cummings at kjchome.homeip.net
Fri Apr 20 05:58:15 UTC 2007
OK, a while ago, I setup MythTV on my home server (with a PVR-350 card)
on FC5 before Jarod had updated his instructions for FC5. I muddled
through the installation, using a combination of the FC4 and FC3
instructions, and using RPMS from ATRPMS, I got MySQL, ivtv, and mythtv
all installed an running. Woo Hoo!
I was able to add a new PC5500-HD card to my setup this past Christmas
without any problem. Great! Cool!
Now, I want to add a remote frontend. This requires a change to the
MySQL setup. I have to issue a GRANT command like so:
> $ mysql -u root mythconverg
> mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
> mysql> flush privileges;
My problem? When I try and login to mysql I can't remember the password
I used for root! I am able to login as mythtv, but trying to issue the
"grant all" command gives me:
ERROR 1044 (42000): Access denied for user 'mythtv'@'localhost' to
database 'mythconverg'
Am I scrod? Can anyone tell me how to re-gain root access to my mysql
database?
--
Kevin J. Cummings
kjchome at rcn.com
cummings at kjchome.homeip.net
cummings at kjc386.framingham.ma.us
Registered Linux User #1232 (http://counter.li.org)
More information about the mythtv-users
mailing list