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.
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!