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 DWHS.net, May 19, 2006.

  1. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    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:
    16
    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. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Thanks Dave!
     
Loading...

Share This Page