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.

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:
    6
    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,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
Loading...
Thread Status:
Not open for further replies.

Share This Page