[mythtv] Back and frontend on same machine, mysql on another
mdz at debian.org
Mon Feb 3 22:55:04 EST 2003
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
> 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).
More information about the mythtv-dev