I have added a user/site to one of our virtualmin boxes. I have given that user permission through administration-ownerlimits to “can manage databases” “can manage users”. However we cannot see anywhere to add a simple database user and then assign permission on the database for that user. The user is able to add databases but cannot add database users and/or assign database permissions. Obviously through root login on VM there is a comprehensive navigation to add databases, add users, add database permission, etc. Can you please help to direct us on how to get this working?
The standard Virtualmin workflow is to create a virtual server and this in turn creates the corresponding user as well as a database, with the appropriate permissions. This user can then create more database which he will own.
You do not wish to follow that workflow. You wish to give one of your users the ability to create create additional users and then create databases which will be assigned to the users that have been created, right?
If you get a Pro licence then you could simply make your user a reseller and that would make the entire thing very tidy indeed. But here is one workflow that you could follow from within Virtualmin GPL to get the result you want:
create databases via Virtualmin → Edit Database (under virtual server of your user)
change owner / username in Webmin → MySQL Database Server → Database Permissions button under Global Options
Caveat: you will have to give your user the required enhanced access to Virtualmin to be able to do this. Double check access, your user might have greater access to change ownership of databases than you might like.
We created an initial virtual server for the customer and provided permissions for the user to create sub-servers. The user is creating additional websites using the sub-server utility and is creating a database for the sub-servers. The user is wanting to create a user to associate with the database for the sub-server. It is this ability to create users for the database that seems to be missing.
