Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

Ken.

share|improve this question

2 Answers 2

up vote 0 down vote accepted

If you give people phpMyAdmin and enough privs to create databases, they can create as many databases as they want; and if you give them permissions to grant themselves access to their newly created databases, then you also give them permissions to fiddle with the permissions of anyone else's databases.

You either need to run a separate database server instance for each customer, and let them do their own thing (although it's still open to resource abuse), or put some sort of frontend in place that validates the user's request and does the work on their behalf only if it meets your constraints.

share|improve this answer

use webhosting control panel, ispconfig, virtualmin, vhcs, cpanel, hsphere, etc.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["                  <li><a href=\"//area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2015 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2015.4.24.2525\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Server Fault works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </noscr"], "copyright__copyright__copyright": ["ill open to resource abuse), or put some sort of frontend in place that validates the user's request and does the work on their behalf only if it meets your constraints.\n\nshare|improve this answer\n\nuse webhosting control panel, ispconfig, virtualmin, vhcs, cpanel, hsphere, etc.\n\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}