MySQL:- Starting MySQL: [FAILED]

[Dipak Bhoi]

Hello guys,

Are you getting following error at the time of starting mysql service on server:

# service mysql start
Starting MySQL: [FAILED]

Now you need to check the error logs on server. Login to your server via SSH as a root user and follow the below steps to resolve the issue.

#less /var/lib/mysql/hostname.err

Above command will show the mysql error logs.  You need to find the error in this logs. We have identified the below error.

140531  8:15:04 [Note] Plugin 'FEDERATED' is disabled.
140531  8:15:04 InnoDB: The InnoDB memory heap is disabled
140531  8:15:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140531  8:15:04 InnoDB: Compressed tables use zlib 1.2.3
140531  8:15:04 InnoDB: Using Linux native AIO
140531  8:15:04 InnoDB: Initializing buffer pool, size = 128.0M
140531  8:15:04 InnoDB: Completed initialization of buffer pool
140531  8:15:04 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140531  8:15:04  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140531  8:15:04  InnoDB: Waiting for the background threads to start
140531  8:15:05 InnoDB: 5.5.36 started; log sequence number 4480722
140531  8:15:05 [ERROR] /usr/sbin/mysqld: unknown variable 'record_buffer=1M'
140531  8:15:05 [ERROR] Aborting

140531  8:15:05  InnoDB: Starting shutdown...
140531  8:15:06  InnoDB: Shutdown completed; log sequence number 4480722
140531  8:15:06 [Note] /usr/sbin/mysqld: Shutdown complete

140531 08:15:06 mysqld_safe mysqld from pid file /var/lib/mysql/hostnmae.pid ended

In above error you can see [ERROR] /usr/sbin/mysqld: unknown variable 'record_buffer=1M' .

To resolve this error you need to Remove record_buffer=1M from your my.cnf file and try again.

#vi /etc/my.cnf

Now remove the record_buffer=1M and save the file.

Now try to restart the MySQL service, It should be working now.

Enjoy !!!