[mythtv-users] ANSWER: Can only connect to mysql as localhost

[R. G. Newbury]

Lan Barnes wrote:
> I solved the problem. Basically, the #@!%$# mysql wildcards just don't
> work. However, when I properly add each IP address to the grane
> (mysql.user) table, everything works.
> 
>  grant all on mythconverg.* to mythtv@'192.168.100.30' identified by  
> 'mythtv';
> 
> Repeat for each FE, including the FE/BE.
> 
> Thanks for all the feedback.
> 
I'm coming in late, but I strongly suspect that what needs to be updated 
is the /etc/hosts file on the mysql server.

Then I think you will find that the wildcards work. And localhost will 
work if you have the '127.0.0.1 localhost' line in /etc/hosts.

Geoff