Can't connect to local MySQL server

jca2

• September 18, 2014 06:50

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136
Any ideas?

• 

  mageshm

  • September 18, 2014 12:29

  @jca2, Where you are getting this error message, Can you please elaborate.

  0
• 

  jca2

  • September 18, 2014 13:32

  It shows up in the logs when trying to recompile apache.

  0
• 

  cPanelMichael

  • September 18, 2014 13:33

  Hello :) Are you able to restart MySQL successfully? Does /tmp/mysql.sock exist? If not, please run this command: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
  Thank you.

  0
• 

  jca2

  • September 18, 2014 13:39

  [quote="cPanelMichael, post: 1732622">Hello :) Are you able to restart MySQL successfully? Does /tmp/mysql.sock exist? If not, please run this command: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
  Thank you.
  MySQL does seem to start/restart correctly without displaying any errors.

  0
• 

  cPanelMichael

  • September 18, 2014 14:16

  [quote="jca2, post: 1732641">MySQL does seem to start/restart correctly without displaying any errors.
  Were you able to check to see if /tmp/mysql.sock exists? Thank you.

  0
• 

  jca2

  • September 18, 2014 14:24

  [quote="cPanelMichael, post: 1732711">Were you able to check to see if /tmp/mysql.sock exists? Thank you.
  It does exist but is 0b

  0
• 

  cPanelMichael

  • September 18, 2014 14:26

  [quote="jca2, post: 1732771">It does exist but is 0b
  That is normal because it's a symbolic link. Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0
• 

  jca2

  • September 18, 2014 14:37

  [quote="cPanelMichael, post: 1732781">That is normal because it's a symbolic link. Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.
  Ticket # 5476581

  0
• 

  cPanelMichael

  • September 18, 2014 18:22

  To update, our analysts determined this was related to InnoDB corruption and the user was directed to the following thread: InnoDB Corruption Repair Guide Thank you.

  0

Please sign in to leave a comment.