[mythtv-users] mythfrontend can't connect to backend/database

[starcycle]

This is the error I'm getting, but I can't figure out what's wrong.
mythtv user can log in to mysql on the server. I don't understand why
it says it can't connect to MySQL server on localhost since the IP of
the mysql server is entered in the field.

Also, I noticed the ~/.mythtv directory and files were created with
root:root ownership, which seems kind of weird since it's the user's
directory. The mysql.txt file listed 192.168.0.1 as the database
location, I changed that to the correct IP, but it still didn't work.
Can anyone help sort this out?

==================================================
sero at homer:~ $ mythfrontend
2008-04-20 12:50:11.763 Using runtime prefix = /usr, libdir = /usr/lib
2008-04-20 12:50:12.425 XScreenSaver support enabled
2008-04-20 12:50:12.425 DPMS is active.
2008-04-20 12:50:12.426 Empty LocalHostName.
2008-04-20 12:50:12.426 Using localhost value of homer
2008-04-20 12:50:12.436 New DB connection, total: 1
2008-04-20 12:50:12.437 Unable to connect to database!
2008-04-20 12:50:12.437 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.1' (111) # [?????]

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 12:50:12.489 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...

2008-04-20 12:50:12.673 UPnPautoconf() - Found one UPnP backend
2008-04-20 12:50:12.702 Unable to connect to database!
2008-04-20 12:50:12.702 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 12:50:12.753 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 12:50:12.803 Cannot login to database?
2008-04-20 12:50:13.812 Total desktop dim: 1680x1050, with 1 screen[s].
2008-04-20 12:50:13.812 Using screen 0, 1680x1050 at 0,0
2008-04-20 12:50:13.813 Switching to square mode (blue)
2008-04-20 12:50:13.869 Using the Qt painter
mythtv: could not connect to socket
mythtv: No such file or directory
2008-04-20 12:50:13.872 lirc_init failed for mythtv, see preceding messages
2008-04-20 12:50:13.885 JoystickMenuClient Error: Joystick disabled -
Failed to read /home/sero/.mythtv/joystickmenurc
QSettings::sync: filename is null/empty
QSettings::sync: filename is null/empty
QSettings::sync: filename is null/empty
QSettings::sync: filename is null/empty
2008-04-20 12:50:16.752 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 12:50:16.753 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 12:50:16.753 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 12:50:16.753 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 12:50:21.299 User cancelled database configuration
2008-04-20 12:50:21.405 Failed to init MythContext, exiting.
=========================================================