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,213
    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. NabiKAZ

    Problem installing mysqlnd_qc from Module Installers

    NabiKAZ, May 18, 2019, in forum: EasyApache
    Replies:
    2
    Views:
    1,313
    NabiKAZ
    May 23, 2019 at 8:01 PM
  2. Kim_Vila

    Problem authenticating with root on MySQL (CLI)

    Kim_Vila, Apr 11, 2019, in forum: Database Discussion
    Replies:
    9
    Views:
    269
    Kim_Vila
    Apr 17, 2019
  3. SamSpade

    Upgrade MySQL 5.6 to MariaDB 10.3 fails due to repo problem

    SamSpade, Mar 3, 2019, in forum: Database Discussion
    Replies:
    6
    Views:
    932
    cPanelMichael
    Mar 11, 2019
  4. Havri

    SOLVED ALT-PHP MySQLi typo3 problems

    Havri, Jan 22, 2019, in forum: CloudLinux
    Replies:
    2
    Views:
    540
    Havri
    Jan 24, 2019
  5. Gastón

    Problem after mysql root change CPANEL 74 / MySQL Server

    Gastón, Aug 29, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    1,063
    steven_h
    Sep 17, 2018

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