Create a database

create database mydb;

Create use and assign privileges to said user

GRANT ALL ON mydb.* TO 'user' IDENTIFIED BY 'password';