#24 revoking grants and hosts problem with webmin
Hi there.
There are 2 problems residing in the newest Webmin
version still, with Mysql.
1.) When adding a user, one can choose to let the user
access the mysql server by specified host or one can
choose the "any" host option.
When choosing the "any" host option, when trying to
connect one gets the 1045 access denied notice, no
matter which host is choosen, no matter if the -h
parameter is used or not.
When having specified a host like "localhost" there is no
problem.
This is good to see when you log into the mysql server
as root and issue the command:
mysql> SELECT * FROM user;
The use in which the "any" option was selected has no
entry in the hosts list, not even a * and so is not able to
login to the database entirely.
2.) When creating a new user in the user table of
Webmin one can grant rights to this person by selecting
which grants you want to give.
But when made a mistake and want to set the privileges
to "none" again (f.e. if you only want to grant privileges
in the users own table instead of in the mysql table)
there is no possibility to choose for "none" and always 1
options stays selected, one can not blank that one out.
These are not really bugs (nja, maybe nr. 1 is) so thats
why I did not post them as a bug but posted them here.
Kind regards,
R. Geerts
rgeerts@publishnet.nl
