[mythtv-users] Weird Database Errors

Michael T. Dean mtdean at thirdcontact.com
Tue Apr 11 17:21:29 UTC 2006


On 04/11/2006 12:59 PM, Mache Creeger wrote:
> Thanks for the quick response. 
>
> I worked on the stuff described in the URL#1 HOWTO with no luck.  
> Given my lack of understanding regarding MySQL, URL#2 looks pretty 
> hairy.  I have the data backed up from the machine so I am able to do 
> a full reload of FC5 and Myth from bare metal.  From a time 
> perspective that seems like the most efficient thing to do to solve 
> the problem.
>
> I am assuming something critical go broke in the bowels of MySQL and 
> it would take a long time (or never) to fix it.  The quick fix to the 
> problem is doing a full FC5 and Myth reload.  I hope I do have a 
> repeat error for a second time. 

Actually, you just need to give the mythtv user permission to access the 
database.  You'll get the same error with a new install if you don't 
configure MySQL to give mythtv permissions...

See the GRANT lines in the MythTV HOWTO.  (And, make sure you're not 
running MySQL with the skip-networking option as described at 
http://mythtv.org/docs/mythtv-HOWTO-22.html#ss22.4 )

Mike

>
> -- Mache
>
> At 09:21 AM 4/11/2006, Michael T. Dean wrote:
>> On 04/11/2006 11:47 AM, Mache Creeger wrote:
>> > Anyone have any ideas about this?
>>
>> http://mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2
>> http://dev.mysql.com/doc/refman/4.1/en/access-denied.html
>>
>> Mike
>>
>> >
>> > -- Mache Creeger
>> >
>> > At 09:00 PM 4/10/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)
>> >>
>> >> 2006-04-10 20:49:12.914 DB Error (KickDatabase):
>> >> Query was:
>> >> SELECT NULL;
>> >> No error type from QSqlError?  Strange...
>> >> 2006-04-10 20:49:12.966 Database not open while trying to load
>> >> setting: GuiVidModeWidth
>> >> 2006-04-10 20:49:12.969 Unable to connect to database!
>> >> 2006-04-10 20:49:12.969 Driver error was [1/1045]:
>> >> QMYSQL3: Unable to connect
>> >> Database error was:
>> >> Access denied for user 'mythtv'@'<myservername>.<mydomain>.COM'
>> >> (using password: YES)
>> >>
>> >> _______________________________________________
>> >> mythtv-users mailing list
>> >> mythtv-users at mythtv.org
>> >> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>> > 
>> ------------------------------------------------------------------------
>> >
>> > _______________________________________________
>> > mythtv-users mailing list
>> > mythtv-users at mythtv.org
>> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>> >  
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users 
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>   



More information about the mythtv-users mailing list