MySQL create a new user

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT privilege ON database.table TO 'username'@'%';

The above can be combined into one as;

GRANT privilege ON database.table TO 'username'@'%' IDENTIFIED BY 'password';

To grant basic permissions on a specific database or table. for example;

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT EXECUTE ON database.* TO 'username'@'%';

which would allow the username to run procedures in the specified database and nothing else.

The following may also be of use;

GRANT ALL PRIVILEGES ON *.* TO  'username'@'%' IDENTIFIED BY 'password';

GRANT GRANT OPTION ON *.* TO  'username'@'%';