WebHostPro

Well-Known Member
PartnerNOC
Jul 28, 2002
1,715
28
328
LA, Costa RIca
cPanel Access Level
Root Administrator
Twitter
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

Well-Known Member
Apr 7, 2003
888
1
168
arkansas
cPanel Access Level
Root Administrator
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