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?
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
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.
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).