We've recently begun to have some downtime due to our database server (MySql) stops responding/refuses connections. We get the following (a lot) when we monitor with mytop:
5033 unauthent 18.104.22.168 0 Connec login
The IP is our own and should be allowed to connect to the server, and it works most of the time.
Some MySql distribution info:
Ver 14.12 Distrib 5.0.27, for portbld-freebsd6.2 (amd64) using 5.0
- Does anyone have any idea of why this would happen and what it means?
- How can we resolve this issue?
- A search on google for mysql unauthent gave lead me to a forum thread which says the problem was resolved by starting mysql with the flag --skip-resolve-names. What does this flag do and what are the consequences of enabling it?
We are getting pretty desperate here, so quick responses would be MUCH appreciated. Thanks!