CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE USER 'myuser'@'%' IDENTIFIED WITH 'mysql_native_password' BY 'mypassword'; GRANT ALL PRIVILEGES ON `mydatabase`.* TO 'myuser'@'%'; FLUSH PRIVILEGES;