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 Root password on 11.34.0 (9)

Discussion in 'General Discussion' started by Astral God, Nov 14, 2012.

  1. Astral God

    Astral God Well-Known Member

    Joined:
    Sep 27, 2010
    Messages:
    180
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    Hi.

    After (auto) upgrade, can't launch ANY tool that connects to the database (Munin, CSF, SQL Tunner...)
    I thought that root password was changed, but when i try to change it ( SQL Services > MySQL Root Password) i get:

    Code:
    MySQL Root Password
    MySQL password change failed!!
    A forced reset will now be attempted.
    ..found binary [/usr/sbin/mysqld]..
    
    Waiting for mysql to terminate.....Done
    Waiting for mysql to restart.....Done
    Waiting for mysql to terminate.....Done
    
    Restarting MySQL ....
    
    Waiting for mysql to restart.....finished.
    
    mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/hostname.pid) running as root with PID 3744 (process table check method)
    mysqld (/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/hostname.err --open-files-limit=3072 --pid-file=/var/lib/mysql/hostname.pid) running as mysql with PID 3868 (pidfile check method)
    
    mysql started ok
    
    Done
    
    The MySQL root password has been changed.
    Password changed for root to xxxxxxxxxx
    
    But password is NOT changed i think; Munin does'nt work, SQL Tuner always request my password and, even after changing it it says that may password is not good.

    What's wrong doc ? :confused:

    Thanks.

    EDIT: Forget, bad entry at my.cnf...sorry !
     
    #1 Astral God, Nov 14, 2012
    Last edited: Nov 14, 2012
Loading...

Share This Page