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.

Once again, mysql problem

Discussion in 'General Discussion' started by Secret Agent, May 3, 2005.

  1. Secret Agent

    Secret Agent Guest

    Mysql error in restart WHM:
    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "mysql has failed").

    Error when resetting root mysql password:

    Mysql password change failed!!
    A forced reset will now be attempted.
    Reset Mysql Password

    Waiting for mysql to restart.....Done
    Changing Password....Done
    Fixing Mysql Privilege Table....This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.

    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

    You can safely ignore all 'Duplicate column' and 'Unknown column' errors
    because these just mean that your tables are already up to date.
    This script is safe to run even if your tables are already up to date!

    Got a failure from command:
    /usr/bin/mysql --no-defaults --force --user=root --host=localhost --password=3esTe2ub --database=mysql
    Please check the above output and try again.

    If you get an 'Access denied' error, you should run this script again and
    give the MySQL root user password as an argument with the --password= option
    Done
    Reloading Mysqld...
    Done
    Waiting for mysql to terminate.....
    Restarting mysql....Starting MySQL...................................[FAILED] Done
    The Mysql Root Password has been changed
    Password changed for root to 3esTe2ub




    End of /scripts/mysqlup --force

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Got a failure from command:
    /usr/bin/mysql --no-defaults --force --user=root --host=localhost --password=3esTe2ub --database=mysql
    Please check the above output and try again.

    If you get an 'Access denied' error, you should run this script again and
    give the MySQL root user password as an argument with the --password= option
    Install Complete

    /etc/my.cnf shows

    [mysqld]
    set-variable = max_connections=500
    safe-show-database



    The /tmp shows the mysql.sock and so does /var/lib/mysql

    I removed the server.domain.pid.err file as well, restarted, same error

    Please help
     
    #1 Secret Agent, May 3, 2005
    Last edited by a moderator: May 3, 2005
  2. Secret Agent

    Secret Agent Guest

    Fixed:

    chmod 1777 /tmp
     
Loading...

Share This Page