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.

MySql failed No mysql.sock file on the system

Discussion in 'General Discussion' started by thehostinghut, Oct 29, 2005.

  1. thehostinghut

    thehostinghut Well-Known Member

    Joined:
    Jan 5, 2005
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16
    Well before anyone asks I did do a search for missing mysql.sock and mysql.sock and any other kinds of searches for missing mysql.sock file. So far no solution in here had fix it.

    Here is the deal I don't think that MYSQL is getting installed or fully installed.

    I have noticed that I get scriptlit failed and exit on a few packages that it tries to download and install.

    There is not a mysql.sock file anywhere on the server. I have tried to force a sql update. Can't symlink to it because there is none.

    I have sent a email to the datacenter to have them look at it in the mean time. I was hoping someone may have an answere.

    System info.

    WHM 10.8.0 cPanel 10.8.1-C9
    CentOS 4.2 i686 - WHM X v3.1.0

    If you need any other info let me know

    Tracy
     
  2. thehostinghut

    thehostinghut Well-Known Member

    Joined:
    Jan 5, 2005
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16
    Since no one knew the answer here is what fixed it for me. Some of it was in this forum I think.

    What needs to be done is, edit /etc/my.cnf and remove the old_passwords=1 line. After than, run: mysql_install_db --user=mysql

    It`s a known issue with CentOS, installing MySQL support for 3.x compatability.

    I hope this helps someone out.

    Tracy
     
  3. clanoutpost

    clanoutpost Registered

    Joined:
    Mar 19, 2005
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    THANK YOU what a nitemare this has caused
    I did what you said and im back in the game.
    :)
     
  4. thehostinghut

    thehostinghut Well-Known Member

    Joined:
    Jan 5, 2005
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16
  5. jackie46

    jackie46 BANNED

    Joined:
    Jul 25, 2005
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    0
    We did know the answer! Next time, try searching! The answer is posted about 200 times in the forums. :rolleyes:
     
  6. thehostinghut

    thehostinghut Well-Known Member

    Joined:
    Jan 5, 2005
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16
    I did say some of it was in the forums. SO YES I did search. If you would have read my opening post you would have seen that also. :eek:

    So you may want to read the post before posting.

    Tracy
     
  7. b0072k1

    b0072k1 Well-Known Member

    Joined:
    Dec 30, 2004
    Messages:
    133
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Glasgow
    what do u mean ?

    After than, run: mysql_install_db --user=mysql ?
     
  8. ramprage

    ramprage Well-Known Member

    Joined:
    Jul 21, 2002
    Messages:
    667
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Canada
    Usually /scripts/restartsrv_mysql adds it if its gone missing.

    Once you run that and it restarts try:

    mysqladmin processlist

    That will tell you if you can connect to the server and its working
     
Loading...

Share This Page