| 1 |
> I just installed on PC1 (pc-0001.localarea) mysql and bind. locally all OK. |
| 2 |
> when I try to connect via phpmyadmin from PC2 (pc-0002.localarea), the |
| 3 |
> following error prompts: |
| 4 |
> |
| 5 |
> Host '192.168.0.2' is not allowed to connect to this MySQL server |
| 6 |
> |
| 7 |
> - on my server, I inserted a new record for host=pc-0002.localarea in |
| 8 |
> mysql.user table with the correct user&password, but it seems that somewhere |
| 9 |
> mysql can not to resolve client's IP. Of course, if I insert a new |
| 10 |
> host=192.168.0.2 record, it works fine, but I prefere to use hostnames. |
| 11 |
|
| 12 |
If you have net-dns/bind-tools installed |
| 13 |
what's the output of dig -x 192.168.0.2 ? |
| 14 |
|
| 15 |
Are you using FQDN in mysql tables? |
| 16 |
|
| 17 |
You should use GRANT statements instead of hacking |
| 18 |
mysql tables directly and FLUSH PRIVILEGES afterwards. |
| 19 |
|
| 20 |
HTH, |
| 21 |
Sasha |
| 22 |
|
| 23 |
-- |
| 24 |
gentoo-user@g.o mailing list |
Archives