The “mysql” service failed to start.

Oct 24, 2014
7
0
1
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
 

24x7ss

Well-Known Member
Sep 30, 2014
272
17
68
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,219
463
Hello,

Are you sure there are no additional lines before the [mysqld] entry in your /etc/my.cnf file?

Thank you.