[mythtv-users] ANSWER: Can only connect to mysql as localhost
R. G. Newbury
newbury at mandamus.org
Sun Aug 12 23:57:01 UTC 2007
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
> 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.
More information about the mythtv-users