I have a dedicated server, which went down without any reason. I am runing a couple of phpBB databases there.
Now when I try to access the phpBB from browser, I get the following message. Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Using Shell, I logged in ran the command 'service mysqld status' it showed: 'mysql dead but subsys locked' tried to 'restart' it, Stopping -> [FAILED], Starting -> [OK] Tried to reboot the server a couple of times, but no gains, the problem still stands there. Searched the net for possible solutions, and I have tried the following solutions till now without any outcome. 1- Try chowning /var/lib/mysql to chown -R mysql.mysql /var/lib/mysql 2- You may want also to remove the lock file from '/var/lock/subsys/' which is 'mysqld'.After this, restart the mysql daemon, and run mysql. I tried and removed mysql file there many times, without any outcome. 3- killall -9 mysqld ---> may take a couple of attempts then... /etc/rc.d/init.d/mysqld restart mysql should turn over and run fine again. Tried it and got : mysqld: no processes killed --------------------------------------------------------------------- Can anyone help me as what to do next? Thanks in advance for any help as I am desperately looking for some solution. Thanks, Sara.
