Hi Edwin,

I'd like Multisites to automatically create a new database via the template instead of me creating the new database first in my cpanel.

I've been speaking to my host and they have said this is possible via SSH.

Is this supported by multisites?

Thanks and regards.

Create a new DB dynamically does not require SSH but require a MySQL user with the privilege to create the DB.

Yes JMS can create the DB dynamically when you have such MySQL user with the appropriate privileges.

JMS can also create MySQL user dynamically.

Hi Edwin,

Is this information in a tutorial or the user manual? If so what page?

Also, my host is currently finding out if this is possible with their MySQL security settings. If it is not possible then can we find a way via SSH? (they have already confirmed that SSH is possible).

Thanks and regards.

The Page 14 - "multisites.cfg.php" where you can also setup the MySQL root login and password.

Setup the parameter
MULTISITES_DB_GRANT_HOST
MULTISITES_DB_ROOT_USER
MULTISITES_DB_ROOT_PSW

Thanks for that information Edwin, I would have never noticed (or recognised the importance) of that in the manual.

My host has confirmed that they cannot give me a super user database login and they have said the only way I can create databases on the fly outside of the control panel is via SSH.

If I was to purchase support hours to work out a solution for this via SSH what would be the estimated number of hours?

I don't think that you could execute SSH script from a PHP application.
If your provider does not gave you the MySQL user privilege to do it, I don't see how you can have more MySQL user privilege from a SSH terminal as you also need to provide a MySQL user with enought privileges.

I don't know how this can be done with SSH from a PHP script.
If your hosting provider can give the description of how it is possible, perhaps I could estimate a workload. For the moment, with the current information, I think this is not possible.