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!

/usr/bin/mysqladmin: connect to server at 'localhost' failed error:....

Discussion in 'General Discussion' started by woody200456, Dec 25, 2006.

  1. woody200456

    woody200456 Member

    Joined:
    Aug 6, 2005
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    For some reason i get this error trying to restart mysql:

    /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").

    how do i fix thanks in advanced.
     
  2. helpline

    helpline Guest

    Hello,

    What is the mysql version that you are using?

    killall -9 mysqld
    killall -9 mysqld

    chown mysql.mysql /var/lib/mysql

    /scripts/restartsrv mysql


    check mysql log for additional errors, if any and post them. Also try to reset your MySQL root password and the restart mysql service.

    Post your /etc/my.cnf file, if problem persist.
     
  3. NogomHost

    NogomHost Registered

    Joined:
    Dec 24, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    151
    To me this same problem. Please explained in the commentary, more than that


    What is the mysql version that you are using?

    I used Release mysql (4.1.21-standard)
     
  4. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    /scripts/restartsrv_mysql should fix the issue. Check mysqld.log for more information.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. almoo7

    almoo7 Member

    Joined:
    Mar 13, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    151
    I'm having the same problem, I get this error:

    /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").

    My mySQL version is 4.1.21

    This is from the mysqld.log

    061229 11:00:57 mysqld ended

    061229 11:00:58 mysqld started
    061229 11:00:58 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Ple$

    061229 11:00:58 [ERROR] Aborting

    061229 11:00:58 [Note] /usr/sbin/mysqld: Shutdown complete

    061229 11:00:58 mysqld ended

    061229 11:10:03 mysqld started
    061229 11:10:03 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Ple$

    061229 11:10:03 [ERROR] Aborting

    061229 11:10:03 [Note] /usr/sbin/mysqld: Shutdown complete

    061229 11:10:03 mysqld ended

    061229 14:08:33 [ERROR] Aborting

    061229 14:08:33 [Note] /usr/sbin/mysqld: Shutdown complete

    061229 14:08:33 mysqld ended

    Anyone know how to fix this? Please help, thanks.
     
  6. almoo7

    almoo7 Member

    Joined:
    Mar 13, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    151
    Nevermind, I solved the problem myself. :D
     
Loading...

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