I'm using webmin 1.620 on my ubuntu server 12.04 machine to administrate my MySQL database.
I currently have multiple users in my mySQL server (john, bob, mary) and each has their own individual database with the basic permissions to each (corresponding to their names). None of my users have access to webmin and I don't want them to. The users get to the backend through phpmyadmin 126.96.36.199deb1 (installed through apt)
So, I have:
User | DB ---------------- john | john mary | mary bob | bob
However, I'm adding a new user to my system: steve. I need steve to have access to his own database as well as creating any future databases through phpmyadmin and having access to the one he creates as well (but non others). User steve may not name them all the same or similar (i.e. prefixes) (although I maybe able to verbally enforce this). So, user steve has an initial database and user account I will create through webmin and then a number of additional databases that he creates through phpmyadmin with his user steve having access to them all.
So, I want:
User | DB ---------------- john | john mary | mary bob | bob steve | steve steve | steve2 steve | steve3 steve | <any other DB's he wants created through PMA with any name>
Does anyone have any idea how I might go about approaching this? I'd rather not install virtualmin (which I know has this capability). I've tried giving user permissions to create databases but then the user has access to all the databases (including the mysql database with all the user accounts) and this is obviously not good (I think it grants superuser privileges). I've tried actually granting the 'superuser' privileges as defined in webmin but that has no apparent effect on the PMA side.
Any ideas/thoughts are greatly appreciated.