Weird remote mysql issue

[WebHostPro]

3 servers use a mysql server but the mysql server out of no where will not let one of the three servers connect.

This server was fine for about 6 months but tonight now will not connect.

Turned off the firewalls but the problem still occurred.

Not sure what could cause one of the servers to not connect anymore when no changes from the admin was made. One account changed a password or something but i don't see any relevance.

Any ideas on how to trouble shoot this?

 

[dave9000]

SSH into the database server and see what if anything is in the logs. Also on our remote database servers I always install a secured copy of phpmyadmin with full root access to the databases.

I would look at the mysql.users, mysql.db, mysql.host tables and make sure something did not change the host entries across all the users,databases

telnet into port 3306 and see if mysql answers on that port

That will give you a start on tracking this down

and if all else fails try a reboot

 

[WebHostPro]

Thanks Dave!