The MySQL server is currently offline.

jasonman

• July 02, 2014 11:46

Hello, when I change the password in SSH, there is a error showing in cpanel database as following: Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 140 Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 140 ...caught
In SSH connecting SUCCESS: root@tradeppt [/var/lib/mysql]# service mysql status SUCCESS! MySQL running (25374) root@tradeppt [/var/lib/mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 188 Server version: 5.5.37-cll MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> exit Bye root@tradeppt [/var/lib/mysql]# service mysql status SUCCESS! MySQL running (25374) root@tradeppt [/var/lib/mysql]# service mysql start Starting MySQL SUCCESS!
plase help

• 

  cPanelMichael

  • July 02, 2014 18:23

  Hello :) Please check to see if /var/lib/mysql/mysql.sock is symbolically linked to /tmp/mysql.sock. If not, run this command: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
  Thank you.

  0
• 

  jasonman

  • July 03, 2014 08:09

  Hi Michael, I follow your command and resolve the issue, thank very much! You are very helpful. Thanks you!

  0

Please sign in to leave a comment.