[mythtv-users] Unable to access database from remote client

[Brad DerManouelian]

On Dec 3, 2006, at 5:20 PM, JCA wrote:

>    I am trying to set up a remote mythfrontend client on a box A, to
> connect to the backend in a box B, so far without any success. This is
> what I get when I invoke mythfrontend on A:
>
> 2006-12-03 17:04:01.386 Using runtime prefix = /usr/local
> 2006-12-03 17:04:01.440 XScreenSaver support enabled
> 2006-12-03 17:04:01.441 DPMS is disabled.
> 2006-12-03 17:04:01.461 New DB connection, total: 1
> 2006-12-03 17:04:01.463 Unable to connect to database!
> 2006-12-03 17:04:01.463 Driver error was [1/2003]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to MySQL server on '192.168.0.7' (111)
>
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2006-12-03 17:04:01.542 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-12-03 17:04:01.611 Unable to connect to database!
> 2006-12-03 17:04:01.612 Driver error was [1/2003]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to MySQL server on '192.168.0.7' (111)
>
> and so on.
>
>    The database and mythbackend are running on B, whose IP address
> indeed is 192.168.0.7. A and B are in the same LAN, and they can
> access each other without a problem - except for mythfrontend running
> on A.
>
>    I invoked myth-setup on B and made sure that this is the IP address
> it connects to. Mythfrontend invoked on the backend box runs fine, and
> it is configured on A with the sam MySQL parameters (user name,
> password, database name) as in B.
>
>    What am I missing?

Make sure mysql is accepting connections from remote machines.  
Specifically, the machine from which you are connecting. Usually  
something like this is the most secure way to set it up:
mysql> grant all on mythconverg.* to mythtv@"HostnameOrIPAddress"  
identified by "yourpassword";

There's also a setting in my.cnf that may prevent remote access to  
mysql. If there's a line in your my.cnf file that says skip- 
networking, make sure it's commented out so it doesn't skip the  
networking.

-Brad