[mythtv-users] Weird Database Errors
R. G. Newbury
newbury at mandamus.org
Tue Apr 11 19:48:54 UTC 2006
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
More information about the mythtv-users
mailing list