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. raafat1994

    Problem with MySQL database

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

    Problem with Remote mysql

    lifesecond, Mar 4, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    544
    cPanelMichael
    Mar 6, 2017
  3. Masimo

    Mysql overload problem

    Masimo, Nov 20, 2016, in forum: Workarounds and Optimization
    Replies:
    6
    Views:
    455
    Masimo
    Nov 24, 2016
  4. Sebastian Sivori

    Mysql problem sql_mode WHMCS

    Sebastian Sivori, Jul 20, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    484
    cPanelMichael
    Jul 20, 2016
  5. Rafael Martins

    Problemas com o MYSQLI

    Rafael Martins, Jun 30, 2016, in forum: Discussões em Português
    Replies:
    2
    Views:
    603
    cPanelMichael
    Jun 30, 2016

Share This Page