mysql can't start

[letux]

i'am used 'yum update mratwork-* -y'  and try 'yum replace mysql --replace-with=mysql55' agin . it's working to replace now

[letux]

still have the same problem

Code: [Select]

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
and httpd service is down !

i don't know what happend in server O.o

[letux]

output of ' ps -ef |grep mysql '

Code: [Select]

root       595  1417  0 18:18 pts/0    00:00:00 grep mysql
and output of 'ls -l /var/run/ | grep mysqld'

Code: [Select]

drwxr-xr-x  2 mysql     mysql     4096 Jan 31 18:40 mysqld
output of 'sudo mysql -u root -p'

Code: [Select]

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[Kloxo-DR]

1) Reboot the server.

2) Install privileges in mysql

Substitute YOUR_MYSQL_PASSWORD and YOUR_KLOXO_PASSWORD in commands below:

Then first execute:

service mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root

mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('YOUR_MYSQL_PASSWORD') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit;

service mysqld start

3) Update privileges in mysql

Thereafter execute:

sh /script/fix-program-mysql YOUR_MYSQL_PASSWORD
sh /script/reset-mysql-root-password YOUR_MYSQL_PASSWORD
sh /script/resetpassword master YOUR_KLOXO_PASSWORD

4) Make sure all is updated

sh /script/cleanup

Reboot the server - only if - there was a php update.
Thereafter:

sh /script/restart-all

[Kloxo-DR]

If one of the tables did crash, then try:

sh /script/mysql-optimize --select=optimize
OR
sh /script/mysql-optimize --select=repair

Did you identify if kloxo/vpopmail could connect with the database? If not one should concentrate on that as well, to exlude that possibility.

For resetting the password, see my post in the past or let me know to give you that info.