[mythtv-users] mysql setup on 'new' backend machine

[Jarod Wilson]

On Monday 30 January 2006 17:16, Kirby Bakken wrote:
> I'm having trouble accessing MySql on my 'new' backend machine.  I've
> followed the instructions and setup the mythdatabase:
>
> mysql < /usr/share/mythtv/database/mc.sql  (running gentoo)
>
> granted access on the same subnet:
>
> $ mysql -u root mythconverg
> mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by
> "mythtv"; mysql> flush privileges;
>
> on the backend machine I can do this:
>
> mysql -u mysql
>
> but I can't do this:
>
> mysql -u mysql -h 192.168.1.8  (the machine tcp address is static and set
> to that)
>
> so, obviously if I can't access the db using the host address on the same
> machine, I can't access it from my frontend....  what am I doing wrong?

Try:

mysql -u mythtv -h 192.168.1.8

The mysql account is usually only set up for localhost access by default, and 
the account you just set up for remote access is mythtv.

-- 
Jarod Wilson
jarod at wilsonet.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20060130/51159f3a/attachment-0001.pgp