Mythfrontend will not connect to backend.

[W3BMAST3R101]

Whenever i try to use my frontend to connect to my backend for mythtv i get this error.

2005-07-09 04:30:19.806 Database not open while trying to load setting: Language
2005-07-09 04:30:19.820 Unable to connect to database!
2005-07-09 04:30:19.821 Driver error was [1/1130]:
QMYSQL3: Unable to connect
Database error was:
Host '192.168.0.28' is not allowed to connect to this MySQL server

2005-07-09 04:30:19.821 Database not open while trying to save setting: Language
2005-07-09 04:30:19.838 Unable to connect to database!
2005-07-09 04:30:19.839 Driver error was [1/1130]:
QMYSQL3: Unable to connect
Database error was:
Host '192.168.0.28' is not allowed to connect to this MySQL server

2005-07-09 04:30:30.034 Unable to connect to database!
2005-07-09 04:30:30.035 Driver error was [1/1130]:
QMYSQL3: Unable to connect
Database error was:
Host '192.168.0.28' is not allowed to connect to this MySQL server


I edited the /etc/mysql/my.cnf and I removed the bind-address, but i still have the same error.

any help is welcomed.

[W3BMAST3R101]

I tried to setup an account, but I cannot login i get the following error

2005-07-09 06:20:13.235 Database not open while trying to save setting: Language
2005-07-09 06:20:13.254 Unable to connect to database!
2005-07-09 06:20:13.254 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@192.168.0.28' (Using password: YES)

2005-07-09 06:20:15.452 Unable to connect to database!
2005-07-09 06:20:15.452 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@192.168.0.28' (Using password: YES)

[flindt]

You should not remove the bind address from my.conf.
It should be set to the IP of your servers network card. Or if used only locally set it to 127.0.0.1

And then you have to add the mythtv user to mysql, I used phpmyadmin to do this.