Web Hosting Talk







View Full Version : mysql, how to add dbs to specific usernames?


seattlite
03-07-2002, 05:10 AM
Hello,

I was just wondering how most hosts allow users to add their own mysql dbs? For instance if you give an allowance of 20 mysql databases(for whatever reason), how do people manage to allow a user to create a database and be able to edit the databases that they created(while of course not allowing others to veiw the new dbs).

Im not sure if that was clear, but hopefully the point got across. Can anyone shed some light on this?

serve-you
03-07-2002, 05:13 AM
Usually through a program like phpMyAdmin. Most control panels have a MySQL administration tool similar, that users have access to, and a quota can be set on how many DB's they can create.

-Dan

seattlite
03-07-2002, 05:24 AM
:blush: I did not realize that phpmyadmin had such a quota... Guess I need to take a look at it again... thanks!

serve-you
03-07-2002, 03:09 PM
No, phpMyAdmin does not have a quote itself. The control panel's (plesk, cpanel, ensim etc) control that.

-Dan