[mythtv-users] MySQL mythconverg permissions.... i give up.

[Ed Gradek]

Hi All,

I've spent the last few days trying to figure this out on my own, searching 
the net, asking friends, and I'm all out of options.

I have a backend server with a single capture card (PVR-250)  hostname 
"backend.domain.com", IP 172.30.2.50

I have a frontend server, with TV-Out (EPIA MII 12000) hostname 
"frontend.domain.com" IP 172.30.2.51

Everything was installed based on wilsonet.com's directions, all updates / 
installs via YUM.

Backened works perfect.  I try to load "mythfrontend" from the frontend 
server, i get:

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-03-18 11:46:13.265 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-03-18 11:46:13.322 Unable to connect to database!
2006-03-18 11:46:13.322 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'root'@'frontend.domain.com' (using password: YES)

I've tried all combinations of the permissions section from the 
myth-howto....:
$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
mysql> flush privileges;

....as well as using IP's instead of hostnames (which resolve fine either 
way), firewall's and LinuxSE are all disabled, connecting as "root", etc.  I 
just have no idea what's wrong.  I have NO idea what the mysql commands are 
above, so maybe I have the syntax incorrect?

But can't figure it out.

Any help would be great!  :(

Ed