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';