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 problem ( Urgent Help)

Discussion in 'General Discussion' started by shann, Jul 25, 2003.

  1. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Hi,

    Suddenly mysql start to give some problem on the server and all the site giving this error mesage.

    mySQL error: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)
    mySQL error code: 2002
    Date: Friday 25th of July 2003 10:08:42 AM

    Any help woudl be appreciate.

    When we look at /var/tmp/ there is no mysql.sock file. Any help woudl be appreciate.

    Thanks
    MIke

    cPanel.net Support Ticket Number:
     
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    You should have a symlink to it from /var/lib/mysql/mysql.sock

    cPanel.net Support Ticket Number:
     
  3. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Thanks guys it is fixed.

    cPanel.net Support Ticket Number:
     
  4. moogle

    moogle Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    What's the command to create the symlink?

    cPanel.net Support Ticket Number:
     
  5. euselect

    euselect Well-Known Member

    Joined:
    Aug 3, 2003
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    the command is ln ( man ln )

    example :

    ln -s real_file new_sym_link

    HTH

    Neil

    cPanel.net Support Ticket Number:
     
  6. gundamz

    gundamz Well-Known Member

    Joined:
    Mar 27, 2002
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16

    why should yuo create a symlink to fix this problem?

    cPanel.net Support Ticket Number:
     
  7. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    Different applications look for the mysql.sock file in different locations.

    cPanel.net Support Ticket Number:
     
  8. Munch

    Munch Registered

    Joined:
    Jun 20, 2003
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I didnt work for me...Help!!!

    I created the sym link in /var/lib/mysql/ to /var/tmp/mysql.sock and still recieved the same error.

    Is t suppose to be the other way around? The /var/tmp/mysql.sock is a link. Is that linking to the /var/lib/mysql/mysql.sock and the mysql.sock just doesnt exist?

    Please Help!!!

    cPanel.net Support Ticket Number:
     
  9. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    search google for "mysql error code: 2002"

    cPanel.net Support Ticket Number:
     
  10. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    Execute:

    slocate mysql.sock

    then reply back with the output.

    cPanel.net Support Ticket Number:
     
  11. Blackthorne

    Blackthorne Member

    Joined:
    Feb 1, 2003
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    I had the same problem with /var/lib/mysql.sock, the soft link didn't fix it.

    I updated the permissions on /var/lib/mysql to 755 and mysql works now. :D

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page