Since my suggestion back in 2011 didn’t get done and I noticed some changes here with how suggestions are handled I thought I’d throw this one up again.
I checked the mysql api page to be sure there isn’t already a method of creating a db… if there is please slap me… I’ve missed it.
My site relies heavily on being able to create separate / unique dbs for each client. Currently I need to manually create a ton of empty DBs so something is available when a new client signs up.
I would like to be able to call upon the mysql api to do this. Not only would this save ME valuable time from having to create empty DBs but then I wouldn’t actually have to create the empty DBs… and can just create new ones on the fly.
We can already assign users and permissions so I’m good to go there… if we can get in database creation, my client sign-up process becomes truly automatic.
I already have cron jobs running to empty / drop tables from databases that are no longer used so I can go back and re-use them for the sign-up process for new clients.