[mythtv-users] problem with mysql

[Yan-Fa Li]

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
>