[mythtv-users] new user with error...please point me toward the appropriate reading

Nick Morrott knowledgejunkie at gmail.com
Sun Jan 28 17:10:25 UTC 2007


On 28/01/07, Mike Chandler <michaelachandler at cox.net> wrote:
> On Sunday 28 January 2007 08:19, Nick Morrott wrote:
>
> > For some reason (incorrect installation, tinkering, etc) your frontend
> > system is trying to connect to the wrong database. The MythTV database
> > is usually called 'mythconverg' whereas your log output shows your
> > system trying to connect to 'mysql'.
> >
> > You should have a ~/.mythtv/mysql.txt file (where ~ is the home
> > directory for your frontend user) - open it in a text editor and edit
> > the line:
> >
> > DBName=mysql
> >
> > to
> >
> > DBName=mythconverg
> >
> > Save the file, and then restart the frontend.
> >
> > Nick
>
> Thanks Nick, that fixed that part of my problem, now it looks like I'm back to
> getting mysql to connect. I struggled with this most all day yesterday and
> don't remember how I got it to work at all.
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-01-28 09:00:23.774 Writing settings file /home/mike/.mythtv/mysql.txt
> 2007-01-28 09:00:23.804 Unable to connect to database!
> 2007-01-28 09:00:23.804 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mysql'@'localhost' (using password: YES)

Carefully read the MySQL section in the MythTV docs -
http://mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 - and ensure you have
given access to users wanting to access the mythconverg database.

What stage of the MythTV installation are you at? Why are you
connecting to the database as user mysql? Your mysql.txt file should
normally use user/pass of mythtv/mythtv.

Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin


More information about the mythtv-users mailing list