How to restart Mysql?

Hello,

sometime the mysql go down if i try to restart it from WHM i get this error:


mysql status root 5871 0.0 0.0 4432 488 ? S May05 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/myhostname.com.pid
root 2792 0.0 0.0 2100 960 ? S 16:10 0:00 sh -c /scripts/ckillall -TERM mysqld;/scripts/ckillall -TERM safe_mysqld;/scripts/ckillall -TERM mysqld_safe;/etc/rc.d/init.d/mysql stop;/etc/rc.d/init.d/mysql start

mysql has failed, please contact the sysadmin (result was "/usr/bin/mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)").


i have try also from ssh:
etc/rc.d/init.d/mysql stop
etc/rc.d/init.d/mysql start

service mysql restart


but no way only a server reboot fix the problem, is there any way to skip the server reboot to get mysql back?

Thx

 

 

 

 

Top