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_”.

Advertisements