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.

MySQL wont start in whm

Discussion in 'General Discussion' started by Vint4ge, Mar 4, 2006.

  1. Vint4ge

    Vint4ge Registered

    Jan 23, 2006
    Likes Received:
    Trophy Points:
    MySQL wont start in whm. It gives me an error about a .sock file not existing in /etc/
    -- I have recently ran this:
    [root@chicago:/] ./scripts/mysqlup
    MySQL Setup Script Version 6.1
    This is the MySQL installer for OS FreeBSD
    Package index download failed!
    Package index download failed!
    Waiting for MySQL to restart ...
    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, stored procedures, or
    more secure passwords in 4.1
    Got a failure from command:
    cat /usr/local/share/mysql/mysql_fix_privilege_tables.sql | /usr/local/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
    Please check the above output and try again.
    Running the script with the --verbose option may give you some information
    of what went wrong.
    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
    Waiting for mysql to restart..............finished.
    /usr/local/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
    mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
    Install Complete

    Please help me :D
  2. dropby23

    dropby23 Well-Known Member

    Jan 16, 2005
    Likes Received:
    Trophy Points:
    cd /var/tmp/
    ln -fs /var/lib/mysql/mysql.sock /var/tmp/mysql.sock

    than restart mysql also generally
    /scripts/restartsrv mysql fix those errors about sockets. etc.

Share This Page