Connect to server

mysql -h hostname -u username -p

Create database

CREATE DATABASE databasename;

Grant privileges to new user

GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'hostname' IDENTIFIED BY 'password' REQUIRE SSL;