[mythtv-users] MySQL nightmare setting up MythTV

[Michael T. Dean]

On 06/14/2006 12:31 AM, Hedgy wrote:
> I brought my computer at work today to work on it on lunch time. I was 
> at the step needing to configure MySQL. I followed the instructions on 
> Jarod's site and everything worked fine. I could access MythWeb, 
> mythfilldatabase worked fine, everything was good.
>
> I brought the computer back home, and everytime I try to start 
> mythtvsetup, I get:
> -----------------------------------------------------------------------------------------------------------------
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2006-06-13 22:07:32.675 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-06-13 22:07:33.109 Unable to connect to database!
> 2006-06-13 22:07:33.110 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'192.168.0.8' (using password: YES)
> -----------------------------------------------------------------------------------------------------------------
>
> I'm assuming that this is because I  had a different IP address at work 
> when I configured MySQL.

Yep.  http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html and, 
specifically, http://dev.mysql.com/doc/refman/4.1/en/privileges.html and 
http://dev.mysql.com/doc/refman/4.1/en/access-denied.html

>  I just don't know how to change MySQL. I read 
> so much stuff I'm more confused now then I was before. I tried 
> installing phpMyAdmin to get a better "visual" illustration of what's 
> going on, but every time I try to connect it says "| #1045 - Access 
> denied for user 'root'@'192.168.0.8' (using password: YES) |".
>
> I set up my router to assign 192.168.0.8 to my linux box every time, so 
> that it never change. I had the whole thing working before, a few days 
> ago. I had hardware problem so I re-installed everything... 3 times so 
> far. Can anyone tell me how to get out of this mess please?

might want to try:

mysql -hlocalhost -uroot -p mysql

to log in as root so you can change the grant tables.  If that doesn't 
work, there's always 
http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html

Mike