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.

cPanel 11 MySql Problems

Discussion in 'General Discussion' started by Ishtumba, Jul 13, 2007.

  1. Ishtumba

    Ishtumba Member

    Joined:
    Jul 11, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    I just started with a fresh install of FC6 and cPanel 11 on a dedicated box.

    Everything has gone smoothly, except for the mySQL setup. During the "Wizard", I was asked to change the root password for mysql. The result was this:

    Code:
    Mysql password change failed!!
    A forced reset will now be attempted.
    Main >> SQL Services >> MySQL Root Password
    Reset MySQL Password
    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, or the more secure passwords in 4.1
    Got a failure from command:
    /usr/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
    Done
    Changing Password....Done
    Reloading Mysqld...
    Done
    Waiting for mysql to terminate.....
    Restarting MySQL ....Starting MySQL................................... ERROR! Done
    The MySQL root password has been changed.
    Password changed for root to ************
    What I have tried thus far:

    • /etc/init.d/mysql start results in "Starting MySQL................................... ERROR!"
    • mysql results in "
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
    • I created the mysql.sock file, change it's ownership to the mysql user, and still no luck.
    • I also changed permissions to 700 on /var/lib/mysql/mysql and change it's owner to mysql:mysql... still no luck
    • I had this exact same problem with cPanel 11 and CentOS 4.5.

    Any ideas? I really don't know where to start.. I've searched the forums and have done what others have suggested.

    Thanks,
    Marc
     
  2. Ishtumba

    Ishtumba Member

    Joined:
    Jul 11, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    I'm an idiot..

    Changing ownership of /var/lib/mysql to mysql:mysql fixed it.

    For what it's worth, it appears the cpanel deleted the mysql user for some reason.

    Marc
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Thanks for that. Am checking it out now.
     
Loading...

Share This Page