[mythtv-users] Distributed Myth

[Jarod C. Wilson]

On Dec 15, 2003, at 14:40, David A. Mason wrote:

> If you try a manual connection:
> 	mysql -h sqlserveraddress -D mythconverg -u mythtv -p
> (and provide the password, 'mythtv' by default) you might get an 
> informative
> error.
>
> Your mysql permissions might not be allowing the user mythtv@{address 
> of
> mythbox}. Note that it might be identifying the address of the mythbox 
> by IP
> or by DNS, depending on whether or not you've established reverse DNS 
> on
> your network.

I can't speak for any other distro, but the default permissions for 
mysql on Red Hat are to only allow connections from localhost and 
hostname, so you have to add permissions for anything else.

Try this:

This example assumes your local area network is 10.0.1.0/255.255.255.0, 
adjust accordingly for your network:
$ mysql -u root -p mythconverg
mysql> grant all on mythconverg.* to mythtv@"10.0.1.%" identified by 
"mythtv";
mysql> flush privileges;
mysql> quit

-- 
Jarod C. Wilson, RHCE

Got a question? Read this first...
     http://catb.org/~esr/faqs/smart-questions.html
MythTV, Fedora Core & ATrpms documentation:
     http://wilsonet.com/mythtv/
MythTV Searchable Mailing List Archive
     http://www.gossamer-threads.com/archive/MythTV_C2/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20031215/c58abd62/PGP.pgp