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!

problem with mysql

Discussion in 'General Discussion' started by ramil, May 24, 2006.

Thread Status:
Not open for further replies.
  1. ramil

    ramil Active Member

    Joined:
    Dec 28, 2003
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    156
    Hi,

    I have a problem with mysql: when I want to restart mysql in WHM, got an erro message:
    ======
    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").
    ========

    also, an error in .pid file:
    ========
    Fatal error: Can't change to run as user 'mysql'. Please check that the user exists!
    ========

    the user mysql is exists and have a right permissionson /var/lib/mysql ...

    but now, when I run a command:
    >> su mysql -c "/usr/sbin/mysqld"

    mysql works fine only for 5 minutes ...


    I did everything - mysqlup --force, upcp --force, create sock and pid filesmanually, changed my.cnf file, etc. but no results... Please help...
     
  2. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    30
    Trophy Points:
    158
    cPanel Access Level:
    DataCenter Provider
Loading...
Thread Status:
Not open for further replies.

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