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.

Help MYSQL DOWN!!!!

Discussion in 'General Discussion' started by damainman, Jun 12, 2004.

  1. damainman

    damainman Well-Known Member

    Joined:
    Nov 13, 2003
    Messages:
    515
    Likes Received:
    0
    Trophy Points:
    16
    WHM is showing as MySQL being up, and i even restarted MySQL a few times.. but no one can connect to it
     
  2. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    check the log files, mainly the .err log file, usually named <hostname>.err

    Can you access the mysql client at the prompt or log in that way ??

    try stopping mysql, then kill -9 mysqld and kill -9 mysql then start mysql again.

    what sort of connection error(s) are you getting ?

    Mickalo
     
  3. damainman

    damainman Well-Known Member

    Joined:
    Nov 13, 2003
    Messages:
    515
    Likes Received:
    0
    Trophy Points:
    16
    just connection errors, all my service monitors shows mysql as being up and running... but no one is able to connect to it.

    ex:
    Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2) in /home/user/public_html/inc/connect.php on line 3
    Database Currently Unavailable. Please try again later.

    Server Specs:
    RHE, Cpanel and MySQL (4.0.18-standard)
     
  4. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    did you check to make sure there is a socket file located in the /var/tmp folder ?? This is not a standard location of the socket file, usually in the /tmp or /var/lib/mysql folder if this is a standard RPM installation .

    Not sure why your script is looking for the socket in that folder ?? If the script calls for the socket in specific location, you may need to change that. Or create a symbolic link from the socket file.

    Mickalo
     
  5. damainman

    damainman Well-Known Member

    Joined:
    Nov 13, 2003
    Messages:
    515
    Likes Received:
    0
    Trophy Points:
    16
    well every single website on the entire server is unable to access mysql :(.. but all my service monitors shows it as running.
     
  6. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    Log into the server via SSH, then see if you can connect with the MySQL client at the prompt:
    Code:
    mysql -u <username> -p
    Enter Password:
    
    if you can connect, then execute show variaibles to see where the socket file is located.

    If you can do this, then mysql is running. If it's not running, stop and then start MySQL again. Or try rebooting the server.

    Mickalo
     
  7. Bluexnet2

    Bluexnet2 Active Member

    Joined:
    Dec 4, 2003
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    Try changing the mysql root password in your whm, that help sometimes.

    Carlos
     
  8. rhettnet

    rhettnet Member

    Joined:
    Jun 15, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    damainman,

    I am having the same problem. This began for me just after my server reported failure of a couple of services and self-rebooted.

    I am concerned that it may have been caused by an intrusion caused by an exploit that I thought to be resolved long ago. I am going to try to have a couple of local techs take a look at it.

    If anything is determined, I will make sure to let you know in this thread.

    -Rhett
     
  9. msalo

    msalo Registered

    Joined:
    Oct 3, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1

    I was having this issue also. I just reset the root password for MySQL in WHM, and it fixed it!

    Thanks much!

    -matt
     
  10. tiggerific

    tiggerific Active Member

    Joined:
    Nov 5, 2003
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Australia
    This just happened exactly the same for me, and totally out of the blue. Exactly the same error message, but changing the WHM root password didn't work. I've restarted both MySQL and Apache - should I try an entire reboot?

    If anyone has solved this in another way, help would be appreciated.

    Thanks.
     
  11. tiggerific

    tiggerific Active Member

    Joined:
    Nov 5, 2003
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Australia
    Thanks anyway - I found the cure for me. Upgrading to the latest stable release solved the problem. I was running cPanel 9.7.7-R15, upgraded to 9.9.1-R3

    Hope that helps someone else.

    Cheers!
     
Loading...

Share This Page