The instructions below are for creating a database for use with WordPress (replace dbname/username/password with your settings):
CREATE DATABASE IF NOT EXISTS dbName COLLATE 'utf8mb4_general_ci';
GRANT ALL ON dbName.* TO 'UserName'@'localhost' IDENTIFIED BY 'Password';
FLUSH PRIVILEGES;
EXIT;