MySQL Commands

Create a new database and user that has all permissions to the new database

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'jsmith'@'%' IDENTIFIED BY 'password';
GRANT ALL ON mydatabase.* TO 'jsmith'@'%';