CODEWITHSUNDEEP
mysqldatabasedatabase-management
Donald Jansen
Donald Jansen

Reputation: 1985

MySQL Privileges To Create Database

Is there a way to create a user in MySQL that have login access but no databases, but it allows the user to create a new database to a limit of 5 or what ever I decide.

So basically what I want is to give a user access to create his own databases, but I dont want him to see other databases, also he should be limited to create only 5 databases

Upvotes: 0

Views: 220

Answers (1)

RandomSeed
RandomSeed

Reputation: 29759

There is no notion of "Database Owner" or "Database Creator" in MySQL, therefore there is no way to limit the number of databases created by a user.

Note: it is possible to put some restrictions at account-level, but not the ones you are looking for. You will need a third-party management tool for this.

Upvotes: 1

Related Questions