Hello guys,
Are you getting following error at the time of starting mysql service on server:
Quote# 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.
Quote#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.
Quote140531 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.
Quote#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 !!!