CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

GRANT ALL PRIVILEGES ON mydatabase.* TO 'newuser'@'localhost';

FLUSH PRIVILEGES;