Re: mysql connection problems

Thus spake Russell Coker:

Anyway I think I've solved this problem. I've edited /etc/hosts on the database server and added entries for every client system. It seems that the MySQL server may have been doing DNS lookups or something. It's been working well since I changed /etc/hosts.

Is there any reason why you don’t maintain a reverse DNS zone for your hosts? Even a $GENERATE–based one would do wonders for sanity. It may be a lot of work, but in the long run it would pay off big time.