ipsrlinuxforum.com

Hello,

I have configured Mysql-5.6.0., but when i start service of mysql I get the below mentioned error. Please help me to resolve the issue.

[root@skil ~]# service mysql start
Starting MySQL...The server quit without updating PID file [FAILED]b/Mysql-5.6.0/mysql.pid).

There seems to be lots of solutions about how to fix this. Try these, to resolve your issue.

The mysql.socket is no longer visible in /tmp eventhough mysql thinks it is. The .pid file in the mysql data folder is gone and mysql just wont behave without it.

So possible solutions are, first up try a straight restart:

/usr/local/mysql/support-files/mysql.server restart
If that doesn’t fix

Remove /etc/my.cnf or just back it up for now and restart:

sudo mv /etc/my.cnf /etc/my.cnf.bak
Another solution is remove any .err files in the data folder or create missing .pid ones that the error message warns:

anderson@[/usr/local/mysql/data]: sudo /usr/local/mysql/support-files/mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/mysql/data/mysql.pid).
So you could remove the .err files like so:

rm *.err /usr/local/mysql/data/

Another Solution:
Reduce the value of buffer pool size of mysql to 10mb and restart mysql


That's it ...Thanks