[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