I am using PHP-mysql on Linux (RHEL 5.0) For First Time
When I tried to connect to MySQL from my PHP Script using mysqli_connect.
It Displayed The Following Error:
Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'(2)
After googling for hour I found solution to this as stated here.
When I followed that approach and issued command:
service mysqld status
as a root user
I got :
mysql is dead but subsys locked Any one know how to solve this and cause of this error ?
- And Stopping of MySQL
is Giving Output as: FAILED
But PHP is working fine. I’ve tested the
phpinfo(); for Demo.
I’ve installed MySQL in
/usr/local/mysql/bin. Can Anyone Help me in this ? Any help is appreciated.
Thanks in advance.
I had this problem with my OTRS server after I tried to update a to large package.
The solution was:
copy for safty:
cp /var/lock/subsys/mysqld /root/mysqld
than delete it
than close all services that depends on mysql:
service httpd stop service otrs stop
service mysqld restart service httpd restart service otrs restart
System is CentOS 6.x
- tail /var/log/mysqld.log to check the error log
then do the following actions:
chown -R mysql.mysql /var/run/mysqld
service mysqld restart
Simply restarting the mysqld worked fro me on Centos.
first,make sure that /etc/init.d/mysqld is running from /usr/local/mysql/bin
then,kill mysqld ,delete the lock file and restart it.
This (and all sorts of other weird errors) can also happen if you have a full disk. In my case, my /var partition had filled up. Freeing up space allowed mysqld to restart again.
First find the PID number of mysqld:
1. Use top | grep mysqld
2. kill -9 PID
Safe method, works fine with Cent OS
Rebooting the server worked for me. Please remember to start all the services once you reboot in case you haven’t added ‘chkconfig’ for them, lets say httpd, named and mysql.
i use command kill, step by step:
- use command service mysqld status for find PID mysqld
- kill -9 PID
- use command service mysqld status again for find PID mysqld
- kill -15 PID
- check again with command service mysqld status , check until the PID dead OR subsys locked
- use command service mysqld start
The problem I meet in the project is because of the disk space run out.
The server that MySQL is running run out the disk space, business project’s log is too large. The result is that MySQL restart failed.
It is one probability and you can have a try.
du -sh *
service mysqld restart