MySQL - How to Create/Assign a User to a Database
Below shows you the syntax required to assign a user (along with password) to a MySQL database.
This is useful for assigning separate permissions across your databases rather then just assigning root access across the board.
mysql> GRANT ALL ON <DATABASE>.* TO <USERNAME>@localhost IDENTIFIED BY '<PASSWORD>';