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.

The “mysql” service failed to start.

Discussion in 'Database Discussions' started by Mr Kindly Wolf, Mar 27, 2015.

  1. Mr Kindly Wolf

    Mr Kindly Wolf Registered

    Joined:
    Oct 24, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Bakersfield, California, United States
    cPanel Access Level:
    Root Administrator
    Hi my friends server has been having issues and im the one that he always go to for the help but seems i can't find the issue

    Restarting MySQL Server

    Waiting for “mysql” to start …………
    …failed.

    Service Error
    The “mysql” service failed to start.

    Startup Log
    error: Found option without preceding group in config file: /etc/my.cnf at line: 1
    Fatal error in defaults handling. Program aborted
    Starting MySQL. ERROR!

    Log Messages
    150327 15:07:40 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:07:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:07:34 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:07:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:07:28 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:07:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:06:35 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:06:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:06:29 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:06:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:06:23 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:06:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:05:42 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:05:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:05:36 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:05:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:05:30 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:05:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:05:29 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:05:28 [Note] /usr/sbin/mysqld: Shutdown complete
    150327 15:05:26 [Note] /usr/sbin/mysqld: Normal shutdown
    150327 15:03:05 mysqld_safe A mysqld process already exists
    150327 15:02:41 [Note] /usr/sbin/mysqld: ready for connections.
    150327 15:02:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:01:10 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:01:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:01:04 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:01:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:00:58 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:00:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 15:00:46 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 15:00:46 [Note] /usr/sbin/mysqld: Shutdown complete
    150327 15:00:44 [Note] /usr/sbin/mysqld: Normal shutdown
    150327 14:57:30 [Note] /usr/sbin/mysqld: ready for connections.
    150327 14:57:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150327 14:52:26 mysqld_safe mysqld from pid file /var/lib/mysql/ns501273.ip-192-99-201.net.pid ended
    150327 14:52:25 [Note] /usr/sbin/mysqld: Shutdown complete
    150327 14:52:24 [Note] /usr/sbin/mysqld: Normal shutdown
    150327 14:47:22 [Note] /usr/sbin/mysqld: ready for connections.

    mysql has failed. Please contact your system administrator if the service does not automagically recover.


    and when i pull the /etc/my.cnf file it shows

    [mysqld]
    max_allowed_packet=268435456
    open_files_limit=41000
    bind-address=127.0.0.1
    default-storage-engine=MyISAM
    innodb_file_per_table=1
     
  2. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    145
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    Hey,

    Remove this portion "[mysqld]" from your /etc/my.cnf and give it a try !
     
  3. 24x7ss

    24x7ss Well-Known Member

    Joined:
    Sep 30, 2014
    Messages:
    271
    Likes Received:
    16
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    I will suggest you to remove the pid file and then start mysql service or first kill or mysql process and then try it. pid file gets automatically created by mysql there is no need to create it manually.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page