The “mysql” service failed to start.

[Mr Kindly Wolf]

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

 

[triantech]

Hey,

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

 

[24x7ss]

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]

Hello,

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

Thank you.