[mythtv-users] how does mythtv connect to mysql?

Michael Wester mrwester at gmail.com
Wed Mar 16 01:31:58 UTC 2005


I've had my Mythtv box working fine for months.  Yesterday I started
installation of new hardware (pvr-500) and now for some reason my
database is acting up.  I'm having a tough time understanding this
one.  Maybe if I knew a little better how the program accesses the db,
I could figure it out.  I'm not finding any solutions in the archive. 
If you know of one, please kindly point me,

1) When I log in to my x session-kde as root (I know a no no...), I
can start mythbackend and mythfrontend, no problems.
2)  When I log in to my x session- kde as user mythtv, I get errors that :

2005-03-15 17:22:34.161 Unable to connect to database!
2005-03-15 17:22:34.162 Driver error was [1/2005]:
QMYSQL3: Unable to connect
Database error was:
Unknown MySQL Server Host ' mediabox' (1)
couldn't open db

When I go through the setup, I set ip address, indicate user is
mythtv, and set password to mythtv.  Still cannot connect to db.
3) from command line:  
mythtv at mediabox:~> mysql -u mythtv -p mythconverg
I enter password=mythtv and I'm in.

I have a feeling that I'm missing a setting somewhere in mythtv?  but
where?  Thanks for any insight.


More information about the mythtv-users mailing list