I just installed on PC1 (pc-0001.localarea) mysql and bind. locally all OK.
when I try to connect via phpmyadmin from PC2 (pc-0002.localarea), the
following error prompts:
Host '192.168.0.2' is not allowed to connect to this MySQL server
- on my server, I inserted a new record for host=pc-0002.localarea in
mysql.user table with the correct user&password, but it seems that somewhere
mysql can not to resolve client's IP. Of course, if I insert a new
host=192.168.0.2 record, it works fine, but I prefere to use hostnames.
If you have net-dns/bind-tools installed
what's the output of dig -x 192.168.0.2 ?
Are you using FQDN in mysql tables?
You should use GRANT statements instead of hacking
mysql tables directly and FLUSH PRIVILEGES afterwards.
HTH,
Sasha
--
gentoo-user@gentoo.org mailing list
