From: Michael <michael@ac...> - 2002-07-26 12:13:51
I was thinking along the lines that a script will be needed for it.
I tried to give GRANT, and they end up being able to see everything,
which is not good.
This is what I see as being ideal:
User is setup in Usermin.
No DB / DB User is setup.
User creates DB.
User creates DB User.
User assigns DB User access to DB.
User can only see, what he created.
User should be able to change the password for DB User, it needed.
Anything the user does from Usermin in Mysql, no other user can see,
except for the "wheel" group.
The above scenario, will actually make Usermin MySQL, very useful. (I
know it can be done, Cpanel has been doing it for years, I just haven't
been able to look at the setup of it)
I'd write the script myself for Usermin, but my Perl knowledge, is
[mailto:webadmin-list-admin@...] On Behalf Of
Sent: Friday, July 26, 2002 3:44 AM
Subject: RE: MySQL - Usermin
> I have my users, through webmin, so databases can only show up, if
> they have been assigned to the user.
> The only problem I have, is to allow for users to create their own
> DB's, which is something I'm trying to figure out.
Well, I don't know if I got you right, but this should be something you
can set up with the GRANT-Syntax. If you run the server just showing all
the user has access rights for and allow him to create tables on the
server (GRANT CREATE at global level should allow the user to CREATE
DATABASE foo, see MySQL Manual 4.3.1 GRANT and REVOKE Syntax for details
and as well 4.2.* for details about what exactly can be granted/revoked
within MySQL), this should be exactly what you wanted. But I don't know
if these two settings contradict each other because if you allow a user
to create databases he has to have write-access to the corresponding
mysql-table on the server and this usually includes the possibility to
read from it. But perhaps SHOW really won't work anyway. Otherwhise the
only chance you have is to let a script (usercommand, something like
that) create a database using a predefined user with rights to create
databases within the script and then grant the executing user the rights
to have (full) access to the newly created database. (Perl supports
If this is not what you wanted, please let me know.
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
Forwarded by the Webmin mailing list at
To remove yourself from this list, go to