MySQL: Users That Can Only Manage Their Own Databases

CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'NEWPASSWORD';

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

Note that the user can only create databases with the prefix “someuser_”.