MySQL user full permission to own databases

Question

Is there a way of giving a user full permissions to create new databases etc, but cannot access or see databases created by other users? I need multiple users to be able to create their own databases as if super user, but not be able to effect other user databases.

talha2k · Accepted Answer · 2012-04-20 06:58:39Z

2

Some thing like this may help.

GRANT ALL PRIVILEGES ON new_user\_% . * TO 'new_user'@'%';

this will grant new_user only access to database created by himself. You can do the same with others.

Hope this helps.

answered Apr 20, 2012 at 6:58

talha2k

25.5k4 gold badges67 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

DonCallisto Over a year ago

What if the DB doesn't exist and user want to create a new one?

talha2k Over a year ago

database does not have to exist yet. new_user can login and create the database.

likenoother Over a year ago

Does this require all the databases to have the corresponding username as prefix? I need to do this for each database the user will create?

likenoother Over a year ago

I guess what I need to a MySQL installation for each user.

Collectives™ on Stack Overflow

MySQL user full permission to own databases

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related