[mythtv-users] Distributed Myth

[Joel Anderson]

Not sure what distro you're on, but you might want to use one of the example
config files for mysql.  On my RH/FC system I use
/usr/share/mysql/my-medium.cnf, and cat or copy/paste a few lines from the
original that are not in the example.

Also, you can try using '%' for the hostname when you do your grant, then
any host can connect.  You can tighten this up later if you want/need it
more secure, after you get it working.  Oh, and don't forget to 'flush
privileges' after granting them.

HTH!

Regards,
Joel Anderson

----- Original Message -----
From: "Dale Weber" <linuxgeek at thedynaplex.net>
To: <steve_wilton at bigfoot.com>; "Discussion about mythtv"
<mythtv-users at mythtv.org>
Sent: Friday, December 12, 2003 3:16 PM
Subject: Re: [mythtv-users] Distributed Myth


> On Friday 12 December 2003 11:59 am, Steve wrote:
>
> > Can you do from command line on machine with mythbackend
> >
> > $mysql -h db.home.thedynaplex.net -u mythtv -p mythconverg
> > Enter password: mythtv
>
> [root at voyager /etc/init.d]# mysql -h db.home.thedynaplex.net -u mythtv -p
> Enter password:
> ERROR 2003: Can't connect to MySQL server on 'db.home.thedynaplex.net'
(111)
>
> > if it doesn't work, you need to fix perms on database.
>
> I'm thinking it's a permissions problem now.  I just have to find where to
> fix it.  Eithe that, or the mysql server doesn't realize it is supposed to
> answer to 'db.home.thedynaplex.net' yet.  I'm looking into that also.
>
> > if it does, check mysql.txt for correct DBHostName, DBUserName,
> > DBPassword and DBName
>
> I already checked this, and it looks right to me.
>
> 8-Dale
> --
> The Dynaplex Network - http://www.thedynaplex.org
> We support Open Source 100% with Linux and FreeBSD!
> Currently running Gentoo Linux 1.4 and FreeBSD 4.9
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>