Stop Microsoft

Operating Systems => Linux and UNIX => Topic started by: TheQuirk on 19 December 2002, 21:36

Title: users creating their own databases
Post by: TheQuirk on 19 December 2002, 21:36

What premissions would I give new mysql users to create and delete their own databases? I know one of them is "create", but I also that's not all. . .

[ December 19, 2002: Message edited by: Angry Quirky Pirate ]

Title: users creating their own databases
Post by: voidmain on 19 December 2002, 10:38

Hmmm, I normally create databases for my users if they need it and grant them the ability to create/drop all the tables they want (full access to said database). I wouldn't want to give them the ability to create new databases on their own. I believe if you want to do that you are going to have to either grant them all privelages (basically a mysql superuser) or set up a separate instance of mysql for that particular user. But I'm not 100% on this....