getting error on mysql database

mywish1

• September 13, 2014 00:42

hi guys i have deicated server and cpanel install on there so now i m getting error like this Unable to connect to database [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] getting this error how i fix this please help me i need urgent help thanks

• 

  triantech

  • September 13, 2014 05:50

  Hello, This means that your MySQL service is not running. Try to start it via SSH : # service mysql start - Check if you are getting some errors when trying to restart or if the restart goes successful.

  0
• 

  mywish1

  • September 13, 2014 05:56

  [quote="triantech, post: 1729191">Hello, This means that your MySQL service is not running. Try to start it via SSH : # service mysql start - Check if you are getting some errors when trying to restart or if the restart goes successful.
  i did but same issue i have no idea how to fix plz help me [COLOR="silver">- - - Updated - - - when i run service mysql start i m getting this error starting mysql error manager of pid-file quit whiteout updating file so what is issue ?

  0
• 

  iserversupport

  • September 13, 2014 07:39

  What is in the MySQL error log

  0
• 

  triantech

  • September 13, 2014 07:53

  check this log file when you try to start mysql ! # tail -20 /var/lib/mysql/$hostname.err ^ replace $hostname with your server hostname

  0
• 

  cPanelMichael

  • September 15, 2014 12:51

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

  0

Please sign in to leave a comment.