[mythtv-users] mysql setup on 'new' backend machine
Kirby Bakken
kirby at magnaspeed.net
Tue Jan 31 04:36:39 UTC 2006
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
>
>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.
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
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)
More information about the mythtv-users
mailing list