mysql Create Database privilege

Question

Trying to setup a wordpress deployment plugin which uses temporary mysql databases to snapshot a wordpress site.

Can I somehow obtain the "create database" privillege to have multiple dbs under the same login?

That would allow to run queries like:

create table db1.table1 like db2.table1

If it isn't possible to get the privillege, would it be possible to have 2 additional dbs created by support?

I guess another way would be to setup mysql as a custome application?

Accepted Answer

0	You can grant a single user permission to multiple databases using the answer give here: http://community.webfaction.com/questions/803/providing-phpmyadmin-access-to-other-users Hope that helps! permanent link answered 19 Sep '11, 05:09 neeravk 1.5k●3●4●12 accept rate: 41%