This is obvious task when creating new website. For almost every new site we create new database and grant ALL privileges to new user on this database. There is mySQL syntax:

First connect to mySQL under root:

Create empty database:

Allow new user to use database server:

Grant ALL privileges to new user on the database

Finally test to connect to new database as new user:

Now you have new database and new user with ALL privileges on the database.