is it possible with mysql to automatically grant an user (which has CREATE privilege)
ALL privileges exclusively on her new created databases ? (without manually changing rights after the db is created)
MySQL Grant Create and All Privileges on User’s Own Database
MySQL
Related Topic
- MySQL create user and database privileges
- Mysql – oracle – grant all privileges to schema
- Mysql – Is it possible to specify MySQL global privileges for a specific table in all databases
- Mysql can’t create user / grant privileges on existing ones (access denied)
- Mysql – Create thesql database and user with only system root privileges but not thesql root privileges
- Mysql – User with grant permissions cannot grant permissions for new user with and new database
Best Answer
It's possible to grant privileges to any database which name is match some mask. Usually I do this for each new user:
After this command user will have all privileges to any database which name match "userdbname_SOMETHING". He also will be able to create any amount of databases at any time which name match this mask.