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.

Missing mysql.sock

Discussion in 'General Discussion' started by mind-field, Oct 17, 2003.

  1. mind-field

    mind-field Active Member

    Joined:
    Sep 28, 2002
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    I have sent a support ticket to cPanel support as well, but I would like to try here as well.

    It seems from the first time I tried to change my mySQL password during the initial server setup, mysql went buggy.

    Now, the problem is beyond my scope. I tried numerous fixes all over the net, and nothing worked. I have tried to restart restart mySQL to have it create the mysql.sock file, but it failed.

    ANY AND ALL HELP IS WELCOMED!

    You can see the error it is giving now: http://silversynergy.com/mysql.php

    Thanks and God Bless!

    David Garza

    cPanel.net Support Ticket Number: 26856
     
  2. TerraSpeed

    TerraSpeed Member

    Joined:
    Jul 21, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    ln -s /usr/local/lib/mysql.sock /var/lib/mysql/mysql.sock

    Run that?
    and put it into mysql (re)start script.
     
  3. Website Rob

    Website Rob Well-Known Member

    Joined:
    Mar 23, 2002
    Messages:
    1,506
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    Alberta, Canada
    cPanel Access Level:
    Root Administrator
    mind-field, your link posted is invalid and the problem may not be what you think.

    Is it safe to presume you are using RH 9 and mySQL 4.0.x? Sounds like it as you mentioned, restarting mySQL does not automatically create a sock file -- like it did in RH 7.x. Could be the newer version of mySQL as well, I just know that restarting mySQL (for recreating the sock file) no longer works.

    Do you have a file and a sym link (in /tmp) called: mysql.sock?

    mysql.sock -> /var/lib/mysql/mysql.sock=

    If yes, have you have locked yourself (as root) out of mySQL?

    # mysqladmin processlist

    Will give an error if you have.


    Need to know which direction we are going in before someone can provide a decent answer.
     
  4. mind-field

    mind-field Active Member

    Joined:
    Sep 28, 2002
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    I apologize for not replying sooner. The issue was resolved. I am not sure how, I will email Nocster about it.

    But, there was no mysql.sock file to symlink to on the server and you assume correctly, RH 9, cPanel 8.5, Mysql 4.x.

    I will let you know what Nocster says.

    Thanks and God Bless!

    David garza
     
Loading...

Share This Page