/** Just follow the command given below **//:--
---------------------------------------
** First check if you have Spanned processes for mysql by the following command :--
netstat -apn or ps -aux
Then..
service mysql stop
Check for any mysql PID and give the following command with the Process ID
kill -9 PID
killall -e -9 mysqld
Once the process is killed mysql is cleaned from the server.
Check under /tmp partition if you the socket file created like ( mysql.sock --> /var/lib/mysql/mysql.sock ) If not then..
************************************************************
//**Do the following :--
touch /var/lib/mysql/mysql.sock
chmod 0777 /var/lib/mysql/mysql.sock
Then under /tmp
ln -s /var/lib/mysql/mysql.sock mysql.sock ( this command will create the socket linked to /var/lib/mysql/ )
Finally restart mysql server if the problem still persist try to increase the mysql connections from /etc/my.cnf
No comments:
Post a Comment