Learn cPanel

Here’s a quick MySQL query that will setup grants for the specified user, on the specified database:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE ROUTINE ON `user\_database`.* TO 'user_username'@'%' IDENTIFIED by 'password';