Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQLserver through socket

Discussion in 'Database Discussion' started by Jamie McInnes, Feb 11, 2016.

  1. Jamie McInnes

    Jamie McInnes Registered

    Joined:
    Feb 11, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United Kingdom
    cPanel Access Level:
    Website Owner
    When we restart mysql we are getting the following error:

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

    Any ideas?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,704
    Likes Received:
    1,883
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you let us know the output to /var/lib/mysql/$hostname.err when attempting to restart MySQL?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Jamie McInnes

    Jamie McInnes Registered

    Joined:
    Feb 11, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United Kingdom
    cPanel Access Level:
    Website Owner
    Hi Michael,

    You are a star sir... any help as we are tearing our hair out.

    I think we have an issue with some corruption but we can't get it started to start the repair.
     

    Attached Files:

  4. Jamie McInnes

    Jamie McInnes Registered

    Joined:
    Feb 11, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United Kingdom
    cPanel Access Level:
    Website Owner
    Hi Michael,

    To save you some time - we may have sorted it.
     
  5. Jamie McInnes

    Jamie McInnes Registered

    Joined:
    Feb 11, 2016
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United Kingdom
    cPanel Access Level:
    Website Owner
    we did innodb_force_recovery which worked. we then restarted and took the line out and i came up with the same errors.
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,704
    Likes Received:
    1,883
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice