MySQL shared hosting-Security

[Anon]

" How can i provide MySQL shared hosting, so that i can GRANT different users (create/drop/alter) priv for creating their databases without overriding or accessing each others Databases/tables.

PS: From the MySQL Documentation:-
"You cannot specify that a user has privileges to create or drop tables in a database but not to create or drop the database itself."

Thanks in Advance.

[[deleted]]

So what you are asking is: "How can I do something that the manuals says is impossible?" 🙂

You'd have to setup a new webserver, running under a new and unique userid.
This userid would have create and drop database rights.

On this server you'd put a form for create database and for drop database.
The drop-database list should obviously only offer to drop databases that were created by that same user.
Your shared users would then have password protected access to this form.

Suggestion: force a prefix of the user's login or something at the beginning of the database name, so people don't constantly find out that the database name they planned to use was already taken.

[Anon]

My basic req is that i should allot Disk quota for MySQL usage but without each others able to acccess or modify their Database/Tables.

It's something like you allocate disk usage for Web Space and the user can upload/modify/delete any number of files on his own without resorting to a form based access within his space limits.

If MySQL doesn't have such provisions, then where can i find one such package similiar to phpMyAdmin for the above task.

Thanks in Advance.