Create a database
create database mydb;
Create use and assign privileges to said user
GRANT ALL ON mydb.* TO 'user' IDENTIFIED BY 'password';