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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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 ?
     
    #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. jaheem

    Problem mysql restart in whm

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

    permission problem since MySQL 5.6.37 update

    trucmuche, Sep 1, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    427
    cPanelMichael
    Oct 27, 2017
  3. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    502
    cPanelMichael
    May 4, 2017
  4. lifesecond

    Problem with Remote mysql

    lifesecond, Mar 4, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    1,068
    cPanelMichael
    Mar 6, 2017
  5. Masimo

    Mysql overload problem

    Masimo, Nov 20, 2016, in forum: Workarounds and Optimization
    Replies:
    6
    Views:
    845
    Masimo
    Nov 24, 2016

Share This Page