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 Blank Root Password

Discussion in 'General Discussion' started by nathacof, May 15, 2007.

  1. nathacof

    nathacof Member

    Joined:
    Feb 28, 2007
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    This is a bit odd.

    I have a customer who is attempting to setup his root user with a blank mysql password. This is stupid I know, and I've recommended he create a new user with privileges only for the necessary database.

    However while investigating his claims I saw some unusual behavior.

    For example setting the root password in the mysql client to blank works fine. But if you restart the mysqld the password is reset to an automatically generated password. /root/.my.cnf is even updated to reflect the new password.

    I'm restarting the service through the WHM so I'm not sure how the password is being reset.

    Anyone experience this in the past?
     
  2. newphp

    newphp Member

    Joined:
    Dec 27, 2006
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Chongqing,China
    The MySQL user password include root account is in the database mysql,table user,but not in /root/.my.cnf
     
Loading...

Share This Page