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

[Jarod Wilson]

On Monday 30 January 2006 20:36, Kirby Bakken wrote:
> Jarod Wilson wrote:
> >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
[...]
> I'm pretty sure it my 'mysql' setup...  I just don't know (yet) where to
> look....  here's what I've tried:
>
> mythbe ~ # mysql -u mysql -h 192.168.1.8
> ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.8' (111)
> mythbe ~ # mysql -u mythtv -h 192.168.1.8
> ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.8' (111)
> mythbe ~ # mysql -u mythtv
> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
> password: NO)

Whoops, sorry, that should be:

mysql -u mythtv -p -h 192.168.1.8

-- 
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/694bd3e2/attachment.pgp