This guide will show you how to make a new user and assign them all privileges to a specified database.
This is not a unique tutorial but is mainly intended as a quick reference for the author. Hope you find it useful though!
Create new database user along with their password. This will apply to all databases they access.
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
Give user all privileges to a particular database
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
Necessary to apply the changes.