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

[Kirby Bakken]

Jarod Wilson wrote:

>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
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>
Got it....  Thanks for all the tips, pointers, instructions, etc...  I 
needed to comment out these two lines in /etc/mysql/mc.cnf

#skip-networking
#bind-address                           = 127.0.0.1