Create a new mysql user and grant all privileges to them on a database
The following command will create a new user and grant them all the permissions on a database.
grant all privileges on database_name.* to 'username'@'localhost' identified by 'secure_password';
To list the permissions granted to a user
show grants for 'username'@'localhost';