Re: [gentoo-user] mysql, bind and dns hostnames

[Alexander Kirillov <nevis2us@infoline.su>]

> 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