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!

MySQL Sock Error

Discussion in 'General Discussion' started by Mini, Feb 10, 2006.

  1. Mini

    Mini Well-Known Member

    Joined:
    Mar 4, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    156
    Hello,

    I am having this problem where I am getting these errors when I start mysql normally ('/etc/init.d/mysql start').

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    So, I have to start MySQL with the command: /usr/bin/safe_mysqld --skip-grant-tables &

    Which is very annoying at times.. does anyone know what the error is and how to fix it?

    Thanks,
    Mini
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,340
    Likes Received:
    402
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    /tmp/ permissions correct?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Mini

    Mini Well-Known Member

    Joined:
    Mar 4, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    156
    Yes, I believe it's CHMODed to 1777.

    Thanks,
    Mini
     
  4. 24x7team

    24x7team Well-Known Member

    Joined:
    Jan 16, 2006
    Messages:
    67
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    really tough to find
    mysql.sock

    YOu are getting the errors that the sock is missing from the location

    '/var/lib/mysql/mysql.sock'

    That means your sock is been created in /tmp

    So i suggest you to symlink

    cd /var/lib/mysql/
    ln -s /tmp/mysql.sock

    This should resolve the problem...
     
    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