MySQL: Add User + Privileges

Let's say we want to add a new user "Erick Broski" with SELECT privileges on database "userlistdb". mysql> grant SELECT on userlistdb.* to 'erick.broski'@'localhost'; Make sure to set his password: mysql> set password for 'erick.broski'@'localhost'= password('h@ckm3'); Now, lets say we want to