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 Failed to Start/Restart

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

Tags:
  1. Rafael Moreno

    Rafael Moreno Registered

    Joined:
    Mar 27, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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:
    317
    Likes Received:
    23
    Trophy Points:
    18
    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
     
  3. Rafael Moreno

    Rafael Moreno Registered

    Joined:
    Mar 27, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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:
    30,674
    Likes Received:
    646
    Trophy Points:
    113
    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.
     
Loading...

Share This Page