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.

mysql has failed, please contact the sysadmin (result was "mysql is not running").

Discussion in 'Database Discussions' started by brighboss, Apr 12, 2013.

  1. brighboss

    brighboss Registered

    Joined:
    Apr 12, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    VUINvr0.jpg

    I keep recieving this error, mysql will not start. Does any one know how to repair this? All sites on server is down because of this.
     
    #1 brighboss, Apr 12, 2013
    Last edited: Apr 12, 2013
  2. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    Check the mysql log for possible reasons.

    Also whats the error message that you receive while trying to restart MySQL from backend.

    Cheers!!!
     
  3. Tiger singh

    Tiger singh Registered

    Joined:
    Apr 4, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    May the below link will be helpfull to you.

    /http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server
    Plesae check it and confirm.:D
     
  4. moleno

    moleno Active Member

    Joined:
    Jan 31, 2013
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I am also getting the same issue. Today mysql suddenly stopped working. I tried to restart it several times by WHM but failed to start it.
    Then I tried it at SSH . It started but with an error.

    Please help !!!

    ==== Error At SSH===
    root@myserver [~]# service mysql restart
    ERROR! MySQL manager or server PID file could not be found!
    Starting MySQL........................................................................................................ SUCCESS!

    ====Error at WHM , while trying to restart MySql ===

    Waiting for mysql to restart...............finished.

    mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/myserver.pid) running as root with PID 3155 (process table check method)
    mysqld (/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/myserver.err --open-files-limit=50000 --pid-file=/var/lib/mysql/myserver.pid) running as mysql with PID 3241 (process table check method)

    mysql has failed, please contact the sysadmin (result was "mysql is not running").
     
    #4 moleno, May 10, 2013
    Last edited: May 10, 2013
  5. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    You will have to kill all current running MySQL process and then start the MySQL, You can check current MySQL process through following command

     
  6. moleno

    moleno Active Member

    Joined:
    Jan 31, 2013
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Mysql is already running but the issue is once I tried to start it by SSH , I got an error . ""ERROR! MySQL manager or server PID file could not be found!"" . what was this ?

    ==== Error At SSH===
    root@myserver [~]# service mysql restart
    ERROR! MySQL manager or server PID file could not be found!
    Starting MySQL........................................................................................................ SUCCESS!
     
Loading...

Share This Page