The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQLserver through socket

Discussion in 'Database Discussions' 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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page