Right now when you create a "sub-server", you cannot create a mySQL database for it, unless the "parent" domain has mySQL database setup.
I'd like to see this policy change, it should be possible to setup databases at any level in the system assuming that permission has been granted to the user.
The problem with the requirement is that it requires you to create databases which may not get used only to allow a "sub-server" to have their own database.
Just my two cents on the topic as always :-)
Status:
Closed (fixed)
Comments
Submitted by JamieCameron on Wed, 10/07/2009 - 22:20 Comment #1
The reason that a sub-server cannot have MySQL enabled unless the parent does is that database admin logins only exist at the parent server level.
However, it is quite possible for the parent server to have a MySQL login but not databases .. and then you can enable MySQL for sub-servers. This can be setup in two ways :
1) Enable MySQL for the parent server, then go to Edit Databases and delete the default database.
2) Prevent Virtualmin from creating the initial database in the first place, at System Settings -> Server Templates -> Default Settings -> MySQL Database, by changing "Create database as well as login?" to "No".
Does that help?
cool beans!
you are the man...
AGAIN!
heh heh
*** the latter suggestion will work perfectly. ***
Submitted by JamieCameron on Wed, 10/07/2009 - 23:18 Comment #3
Great!
Submitted by Issues on Thu, 10/22/2009 - 11:20 Comment #4
Automatically closed -- issue fixed for 2 weeks with no activity.