MySQL setup

1 post / 0 new
#1 Mon, 07/19/2010 - 17:07

MySQL setup

I'm having trouble getting a MySQL template scheme setup.

Here's what I want:

When I setup a new virtual server, I want a database setup named ${PREFIX}_production. I want a new user created named ${PREFIX}. I want to enter a password for that user that is different from the domain owner's password. I want the user to automatically have permission to do EVERYTHING on it's own database, but permission to do nothing on any other database.

This was fairly easy to do manually in Plesk, which is where I'm coming from, but how do I do this automatically with Virtualmin?