Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL Failed to Start/Restart

Discussion in 'Database Discussion' started by Rafael Moreno, Sep 15, 2016.

Tags:
  1. Rafael Moreno

    Rafael Moreno Member

    Joined:
    Mar 27, 2015
    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Venezuela
    cPanel Access Level:
    Root Administrator
    Hello, I'm haveing some issues with mysql service.

    After change owner and chmod to my.cnf like this

    # chown root:root /etc/my.cnf
    # chmod 0644 /etc/my.cnf
    Based on: CVE-2016-6662 MySQL - cPanel Knowledge Base - cPanel Documentation

    mysql crashed after that, I revert changes but still unable to start mysql:

    Code:
    
    Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/asylum.hostname.com.pid).
    
    root@server[/etc]# service mysql restart
    ERROR! MySQL server PID file could not be found!
    Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/server.hostname.com.pid).
    
    Also from WHM:

    Code:
    Restarting MySQL Server
    
    Waiting for “mysql” to start ……………failed.
    
    Service Error
    (XID jahsub) The “mysql” service failed to start.
    
    Startup Log
    Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/server.hostname.com.pid).
    
    Log Messages
    160915 16:52:55 mysqld_safe mysqld from pid file /var/lib/mysql/server.hostname.com.pid ended
    /usr/sbin/mysqld[0x5933d1]
    /usr/sbin/mysqld[0x59c2ad]
    /usr/sbin/mysqld[0x6ea791]
    /usr/sbin/mysqld[0x97306d]
    /usr/sbin/mysqld[0xa2cac4]
    /usr/sbin/mysqld[0xa3f61d]
    /usr/sbin/mysqld[0xa80111]
    /usr/sbin/mysqld[0xa91eeb]
    /usr/sbin/mysqld[0xa91aa4]
    /usr/sbin/mysqld[0xa7c7ee]
    
    mysql has failed. Contact your system administrator if the service does not automagically recover.
    
    
    Thanks in advance!
     
    #1 Rafael Moreno, Sep 15, 2016
    Last edited by a moderator: Sep 15, 2016
  2. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    604
    Likes Received:
    42
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi,


    You can monitor the MySQL error log while restarting the MySQL server. use below command

    tail -f /var/lib/mysql/server.hostname.com.err
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Rafael Moreno

    Rafael Moreno Member

    Joined:
    Mar 27, 2015
    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Venezuela
    cPanel Access Level:
    Root Administrator
    Thank you @SysSachin, The error was some crashed databases.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,700
    Likes Received:
    1,791
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    I'm happy to see you were able to address the issue. Thank you for updating us with the outcome.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice