Apache Friends Support Forum

MySql database created by the root user with Database-specific privileges for a sub-user won't allow the sub-user to create a new database from that sub account . Only table operations are allowed in this case.

On the other hand database created by the root user with Global privileges or both Global privileges & Database-specific privileges for a sub-user allows sub-user to create database from that sub-account.

The problem is that both the sub-user account and database created with such privileges are merged with root user account and is treated as root account with specific given privileges by the root user.

Is there a way to create MySql database from a sub-user's account that has been granted Database-specific privileges only by the root user?

Altrea wrote::!:
Creating databases is a global permission, so the user who should be able to create a database cannot have database specific permissions only.

Code: Select all

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