The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Weird remote mysql issue

Discussion in 'General Discussion' started by WebHostPro, May 19, 2006.

  1. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,597
    Likes Received:
    10
    Trophy Points:
    168
    Location:
    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?
     
  2. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    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
     
  3. WebHostPro

    WebHostPro Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,597
    Likes Received:
    10
    Trophy Points:
    168
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thanks Dave!
     
Loading...

Share This Page