I've a VPS and am hosting a few peoples websites, namely people who I will have a lot of contact with although would like to provide what I can without being there to do it.
I have written a script to add a sample database and user upon my "account" creation script, i.e.:
CREATE DATABASE <username>_main GRANT ALL ON <username>_main.* TO <username>@localhost IDENTIFIED BY 'randomfoobar';
I am unsure about this, would they need to contact me to run the script to add another database? I was kind of wanting it so they had phpmyadmin (not much trouble for me) and then log in as their user/password, then have a clean phpmyadmin interface where they can add databases and whatnot, of course without affecting others.
Is this possible with mysql? or would I need to completely separate the mysql portion for each user so that they can create databases freely, but not affect other users?