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

2006-07-26 Thread sguglia
Alle 17:17, mercoledì 26 luglio 2006, Alexander Kirillov ha scritto: > Hi Stefano, > > Check your reverse zone. > dig -x 192.168.0.2 on mysql box should give you something like: > > ;; ANSWER SECTION: > 2.0.168.192.in-addr.arpa. 172800 IN PTR pc-0002.localarea. > > Same goes for AUTHORITY SEC

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

2006-07-26 Thread Alexander Kirillov
If you have net-dns/bind-tools installed what's the output of dig -x 192.168.0.2 ? # dig -x 192.168.0.2 ; <<>> DiG 9.3.2 <<>> -x 192.168.0.2 ;; global options: printcmd ;; Got answer: ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 914 ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY:

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

2006-07-26 Thread sguglia
Alle 15:20, mercoledì 26 luglio 2006, Alexander Kirillov ha scritto: > 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 aft

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

2006-07-26 Thread Alexander Kirillov
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

[gentoo-user] mysql, bind and dns hostnames

2006-07-26 Thread sguglia
hello everybody.. 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 recor