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.

myqsl.sock error! URGENT!

Discussion in 'General Discussion' started by blindbasher, Apr 24, 2005.

  1. blindbasher

    blindbasher Member

    Joined:
    Mar 6, 2005
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    hey, my sevrer mysql doesnt work, i tried '/tmp/mysql.sock' and /var/lib/mysql/mysql.sock its not there, i think its been deleted, or somthing, i try service restart and i get /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed"). please help!
     
  2. SeeK6155

    SeeK6155 Registered

    Joined:
    Jan 5, 2005
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    what OS u running?

    i got that alot when running FC2 and FC3 (without cpanel)

    i never figured out what was wrong, so i installed FC1 (but now am changing to cetOS2.4)
     
  3. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Usually all you need to do is:

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

    Then start mysql.
     
  4. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    38
    unluckly it's not enough ... please help !!
     
  5. bijo

    bijo Well-Known Member

    Joined:
    Aug 21, 2004
    Messages:
    475
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    Hey,

    Did you check the mount command?. May be your /tmp directory mounted to /var/tmp. if it is mounted to /var/tmp stop mysql first and umount it. Then restart mysql. May be it will help you to solve this issue.
    /etc/rc.d/ini t.d/chkserverd stop
    /etc/rc.d/init.d/mysql stop
    ps -aux | grep mysql

    if there any musql killall -9 mysqld

    then umount /var/tmp/
    then start mysql.

    Also is there any /usr/local/lib/mysql.sock file?. if no create a soft link

    ln -s /var/lib/mysql/mysql.sock= /usr/local/lib/mysql.sock

    Also check your /etc/my.cnf file

    then start mysql.
    =================================================================
    #ls -l /usr/local/lib/mysql.sock
    lrwxrwxrwx 1 root root 33 Feb 11 07:37 /usr/local/lib/mysql.sock -> ../../../var/lib/mysql/mysql.sock=
    =================================================================

    if it is not work, run this command
    -----------------------------
    /scripts/mysqlup --force
    -----------------------------
     
  6. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    38
    I have mysql sock file on /var/lib/mysql but I continue to receive the password error


    /tmp has his own partition



    I tried EVERYTHING was written on this forum ...

    It's definitely something with WHM/CPANEL !!!
     
  7. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    38
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
     
  8. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    18
    If you could explain the situation a bit more, it would be easier for others to think of what possibly caused it.

    Which OS are you running, did you do any recent upgrades of OS,Cpanel/WHM,Apache,MySQL etc.?

    More people seem to have these issues, so I hope we can figure out what causes this.
     
Loading...

Share This Page