[mythtv-users] problem with mysql
Yan-Fa Li
yanfali at best.com
Tue Dec 21 06:46:36 UTC 2004
You need to either update the host entry in the mysql.user table or
grant the same user rights from your new ip address.
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
>
More information about the mythtv-users
mailing list