[mythtv-users] remote and local database access

Jay jaywardle at prodigy.net
Sun Oct 9 17:34:20 UTC 2005


I am trying to setup a Mac mini with remote MythFrontend.  My main
machine, "mythtv", has the database, a backend and a frontend.
It has been running well for a long time, on Debian unstable and mythTV
Version 0.16.

The remote frontend can connect to the database, but not to the mythtv
backend.  The remote frontend can't connect to the backend because I
can't change DBHostName in the backend machine's /etc/mythtv/mysql.txt
from localhost to the hostname until the database is accessible locally
using the hostname.

I enabled database remote access using the MySQL commands:
grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
flush privileges;

Neither skip-networking and skip-name-resolve are present.
e.g. Both are commented out in /etc/mysql/my.cnf.
bind-address is not present either.


On the main machine, I can still access the database using localhost:
 >> mysql -hlocalhost -u mythtv mythconverg -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 135 to server version: 4.0.22_Debian-6-log
...etc...


Network database access is working because I can access the
database remotely using both MythFrontend and CocoaMySQL.
The remote MythFrontend can display program info in the EPG.


But I can't access the database thru the network on the main machine.
I assume that if I can't access it with the mysql client, then myth 
can't either:
 >> mysql -hmythtv -u mythtv mythconverg -p
Enter password:
ERROR 1045: Access denied for user: 'mythtv at mythtv' (Using password: 
YES)


Is there a different process if the database has already been use as a
single machine system than for an initial setup for multiple frontends?

Any suggestions?

Thanks,
Jay



More information about the mythtv-users mailing list