Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Secret Agent
    Guest

    Default Once again, mysql problem

    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
    Last edited by Secret Agent; 05-03-2005 at 04:54 PM.

  2. #2
    Secret Agent
    Guest

    Default

    Fixed:

    chmod 1777 /tmp

Similar Threads & Tags
Similar threads

  1. Mysql 5.0.91 to MySQL 5.1.48 username problem
    By Tymsah in forum Database Discussions
    Replies: 4
    Last Post: 10-15-2010, 12:39 PM
  2. Mysql problem
    By Webzcas1 in forum New User Questions
    Replies: 2
    Last Post: 12-09-2009, 11:27 AM
  3. mysql problem
    By bmmsr in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 08-23-2005, 04:14 AM
  4. mysql problem
    By shizzle in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 01-10-2005, 01:30 AM
  5. problem with mysql
    By AP in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 12-14-2002, 08:31 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube