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

Discussion in 'General Discussion' started by wavewind, Aug 18, 2007.

  1. wavewind

    wavewind Registered

    Joined:
    Aug 1, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    I've the WHM 11.2.0

    The mysql is not running, when I restart the mysql service, it came up with this:

    Waiting for mysql to restart.... . . . . . . . . . . finished.

    mysql status

    /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").

    I thought maybe I should upgrade mysql but it seems the version is up to date.

    MySQL Setup Script Version 7.0
    Loaded cPPkgs::MySQL ok!
    This is the cPPkgs::MySQL 4.1.22 installer for Linux.
    MySQL 4.1.22 is up to date

    Any help is very appreciated!

    Thanks,
    Stephen
     
    #1 wavewind, Aug 18, 2007
  2. kirkke

    kirkke Registered

    Joined:
    Aug 18, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    #2 kirkke, Aug 18, 2007
  3. magoori

    magoori Registered

    Joined:
    Aug 7, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    I have same problem today :(​
     
    #3 magoori, Aug 18, 2007
  4. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    166
    So did you see if your socket exists in tmp? Even if you don't know, just run through these commands


    cd /var/lib/mysql
    touch mysql.sock
    chown mysql:mysql mysql.sock
    chmod 1777 mysql.sock
    ln -s /var/lib/mysql/mysql.sock /tmp
    chmod 1777 /tmp
    /scripts/mysqlup --force
    /etc/rc.d/init.d/mysql restart
     
    #4 jayh38, Aug 18, 2007
  5. wavewind

    wavewind Registered

    Joined:
    Aug 1, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    Jayh38, Thank you so much! It works!
     
    #5 wavewind, Aug 18, 2007
  6. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    Hi

    Mysql crash.. work within any minute ago, I have changed only a value on my.cnf .. and the try restart.. but crash.

    If try to stop or restart nothing happen :(

    I have try code posted but not work.. he freeze at
    Preparing ....

    :(

    all db is down :'(

    any help ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 webstyler, Dec 7, 2008
  7. kipper3d

    kipper3d Well-Known Member

    Joined:
    Jul 14, 2002
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    156
    I have similar issue however it affects only 1 site.

    Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/xxxxx/public_html/inc/class_db.php on line 12
    Error Connecting to MySQL database

    I am running mysql 5.0.67

    Could it be mysql compatibility issue of the website? We recently migrated that site from a server with mysql 4 to current mysql5


    Other info:
    socks exists in /tmp/mysql.socks
    my.cnf has nothing in it but
    [mysqld]
    skip-bdb

    Thanks!

    -John
     
    #7 kipper3d, Dec 10, 2008
    Last edited: Dec 10, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysql problem
  1. geokat

    Problem after mysql root password change

    geokat, May 17, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    240
    cPanelLauren
    May 18, 2018
  2. jaheem

    Problem mysql restart in whm

    jaheem, Nov 3, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    753
    cPanelMichael
    Nov 3, 2017
  3. trucmuche

    permission problem since MySQL 5.6.37 update

    trucmuche, Sep 1, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    484
    cPanelMichael
    Oct 27, 2017
  4. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    542
    cPanelMichael
    May 4, 2017
  5. lifesecond

    Problem with Remote mysql

    lifesecond, Mar 4, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    1,182
    cPanelMichael
    Mar 6, 2017

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.
    Accept Learn More...
    Dismiss Notice