Login as root mysql user:
<SQL> grant all on mythconverg.* to 'mythtv'@'%' identifed by 'mythtv' flush privileges; </SQL>
substitute your IP address for '%' if you want more security.
Or
<SQL> connect mysql; update user set Host='%' where User='mythtv'; flush privileges; </SQL>
substitute your IP address for '%' if you want more security.
'%' means any host. It's not recommended but it is very convenient if you're network is firewalled behind a NAT gateway and you have multiple frontend boxen.
Yan
ryan wrote:
i changed my local ip and since then i cant log into mysql to update tv listings =\
any ideas?
-chi
_______________________________________________ mythtv-users mailing list [EMAIL PROTECTED] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users