[mythtv] Back and frontend on same machine, mysql on another

[Matt Zimmerman]

On Mon, Feb 03, 2003 at 10:11:52PM -0500, IvanK. wrote:

> I want to run mythbackend and mythfrontend on the same machine, but have
> the mysql server on a different machine.  The mythweb is on the same
> machine that runs mysql and also I want to put a nfs-exported disk to be
> mounted on the first machine.  The mythweb and the nfs part is done.  I've
> also changed mysql.txt to list the correct host, created the correct
> db/tables and granted the correct privileges, created correct .my.cnf for
> mythtv user.  Typing mysql I connect to the remote mysql server and I can
> perform INSERTs and SELECTs and DELETEs, so I know the mythtv user can
> connect to it.
> 
> However, trying to start mythbackend gives me the can't connect to db
> message.
> 
> I'd appreciate any and all help.

You don't need a .my.cnf, and I don't think that the Qt plugin (which mythtv
uses) will read it anyway.  If the settings are correct in mysql.txt this
will work.  I run a similar setup myself, with the database on a remote
machine, and have since I first started using MythTV.  It works.

You only need to specify the correct settings in mysql.txt (including the
username and password).

-- 
 - mdz