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 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:
    166
    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:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    191
    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:
    166
    cPanel Access Level:
    Website Owner
    Thanks guys it is fixed.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. moogle

    moogle Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    156
    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:
    156
    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:
    316

    why should yuo create a symlink to fix this problem?

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. ciphervendor

    ciphervendor Well-Known Member

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

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. Munch

    Munch Registered

    Joined:
    Jun 20, 2003
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    151
    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:
    166
    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:
    166
    Execute:

    slocate mysql.sock

    then reply back with the output.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. Blackthorne

    Blackthorne Member

    Joined:
    Feb 1, 2003
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    151
    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

  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