[mythtv-users] Weird Database Errors

[R. G. Newbury]

Mache Creeger wrote:
> I am running FC5 with 2080 kernel.  On loading mythtfrontend in user 
> mode I get the following errors over and over again.  Note 
> <myservername>.<mydomain> is substituted for my real server and domain name.
> 
> Checking the database
> 
> Anyone have any ideas how to fix this?
> 
> -- Mache Creeger
> 
> 2006-04-10 20:49:12.682 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-04-10 20:49:12.737 Unable to connect to database!
> 2006-04-10 20:49:12.738 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'<myservername>.<mydomain>.COM' 
> (using password: YES)
> 
> 2006-04-10 20:49:12.797 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-04-10 20:49:12.850 Database not open while trying to load 
> setting: GuiVidModeResolution
> 2006-04-10 20:49:12.856 Unable to connect to database!
> 2006-04-10 20:49:12.856 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'<myservername>.<mydomain>.COM' 
> (using password: YES)

The last line is the important one. If you did a fresh install  of FC5, 
like I did, something gets mixed up.
As root, try mysql -u root -p<yourpassword>
 > use mysql;
 > select host,user,password from user;

This will show your hosts, users and whether or not a password is 
required. I think something changed on the upgrade to mysql 5.0.18.

Note that trying to change things in myhttv-setup will not work if the 
user and host combo cannot talk to the database. You may need to re-run 
the mc.sql script to grant privileges. (And in basic form, that grants 
permissions to mythtv at localhost, not at myservername.

Geoff