Hello

I'm a new user of Virtualmin (though I've been using Webmin for years). I'm trying to switch to Virtualmin from Cpanel. So far it's going pretty well and I'm loving the control, but I've come across a problem with MySQL databases.

What I'd like is for users to be able to create databases in the format of uniquename_dbname and have permissions on only their own databases.

I've used the Default Settings template in Virtualmin and changed the "Prefix for additional databases" setting to ${PREFIX}_

At the moment, even though I think all the settings are right, users are created with full permissions for the username's database but not the ability to add any new databases.

Going to the database list in a user's account gives this error:
You are not allowed to manage databases

I must be missing something, what do I need to set to allow users to create databases?

Many thanks in advance

Al

under virtualmin tab, select the domain, go to Administration Options, go to Edit Owner Limits, go to Allowed capabilities and features in the right pane, under Edit capabilities for virtual servers enable the Can manage databases

for new users go to server template and in the scroll down select Default domain owner limits, go to Default editing capabilities, enable Can manage databases

ronald wrote:
under virtualmin tab, select the domain, go to Administration Options, go to Edit Owner Limits, go to Allowed capabilities and features in the right pane, under Edit capabilities for virtual servers enable the Can manage databases
Damn, it was actually that easy! I don't know how I managed to miss that, I'm sure I ticked it earlier! Many thanks ronald.

One little odd thing though, the MySQL module appears under "un-used modules" in the menu. Why would it be there? I googled a bit and someone with a similar issue fixed it by refreshing modules but that didn't work for me. I'd appreciate any clues.

if you go to the module and click on the module config in the left upper corner, then select the System Configuration.

Make sure all the paths are 100% correct and do a refresh again.
If that doesn't help I would submit a support ticket in the bug-tracker

Hi ronald

I've checked the module config and it all looks fine. All the paths seem to go to the binaries.

I'll open a ticket, as you suggest.

Many thanks for your help

MySQL being in unused modules means that MySQL didn't exist or wasn't configured correctly when Webmin was installed. Since it's working now, you can probably just click "Refresh modules" in the Webmin menu (at the bottom).