MySQL Forums
Forum List  »  Newbie

User rights for new database creation
Posted by: Snop Randi
Date: January 11, 2015 07:34AM

Hello,

maybe a totally simple question, but i am struggeling right now:

i have a user (f.eg. "david") who has it's own database ("david") where that user can read/write all tables. Everything works fine.

now i want to enable "david" to create new databases (f.eg. "david_1", "david_2")

my questions:

(a) which rights do "david" need to create databases and
(b) which commands are needed to create that new database incl. setting the necessary rights (read/write/create,drop tables) for user "david" ?

Thanks a lot,
jugi

Options: ReplyQuote


Subject
Written By
Posted
User rights for new database creation
January 11, 2015 07:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.