Here is some code that I use at the beginning of a MySQL database script to (a) create a database, (b) create a local user to access that database ('foo_user'@'localhost'), (c) create a remote user that can access the database ('foo_user'@'%'), and (d) then use that database (which I need to do before starting a bunch of CREATE TABLE statements):

CREATE DATABASE foo;

GRANT ALL PRIVILEGES
ON foo.*
TO 'foo_user'@'localhost'
IDENTIFIED BY 'foo_pass'
WITH GRANT OPTION;

GRANT ALL PRIVILEGES
ON foo.*
TO 'foo_user'@'%'
IDENTIFIED BY 'foo_pass'
WITH GRANT OPTION;

USE foo;

As mentioned, after this point in my script I would follow these statements with all of my CREATE TABLE statements to create my MySQL tables, and INSERT statements to populate my initial database data.