Menu

#404 MySQL module wiping root MySQL password?

0.950
closed
5
2002-03-27
2002-03-27
Anonymous
No

Hello. It seems that the MySQL module manages to lose
the root MySQL password when I take the following
course of action:

-Go to "User Permissions"
-Go to the properties for the root user
-Make sure the password is set to "Don't Change"
-Change the "hosts" setting to "any".
-Save

After I do this, Webmin prompts me to re-enter the
root MySQL password in order to gain administrative
access to the MySQL server. It refuses the correct
password and I end up needing to restore the mysql
database from backup. I've had this happen on two
seperate machines (same OS, MySQL version, and Webmin
version).

Here is my configuration:

Redhat Linux 7.2
MySQL 3.23.41
Webmin 0.950 (RPM Install)

Thanks.

Discussion

  • Jamie Cameron

    Jamie Cameron - 2002-03-27
    • status: open --> closed
     
  • Jamie Cameron

    Jamie Cameron - 2002-03-27

    Logged In: YES
    user_id=129364

    This isn't really a bug in webmin .. if you have a read
    of
    http://www.mysql.org/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Adding_users
    it explains that if you create a user with the Hosts set
    to All, and also have existing anonymous users with a host
    set, then logins will connect as the anonymous user, not
    your root user!

     

Log in to post a comment.