I always for get how to creat a database, user, and granting privileges to the new user for that database:
Query OK, 1 row affected (0.02 sec)
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
Privileges
| ALL |
| ALTER |
| ALTER_ROUTINE |
| CREATE |
| CREATE ROUTINE |
| CREATE TEMPORARY TABLES |
| CREATE USER |
| CREATE VIEW |
| DELETE |
| DROP |
| EVENT |
| EXECUTE |
| FILE |
| GRANT OPTION |
| INDEX |
| INSERT |
| LOCK TABLES |
| PROCESS |
| REFERENCES |
| RELOAD |
| REPLICATION CLIENT |
| REPLICATION SLAVE |
| SHOW DATABASES |
| SHOW VIEWS |
| SHUTDOWN |
| SUPER |
| TRIGGER |
| UPDATE |
| USAGE |