The following two commands create a database on a MySQL server and a user with full permissions inside this database.

Connect to your MySQL server:

mysql -uUSERNAME -hSERVERADDRESS -p

Geben Sie die folgenden zwei Befehle ein:

CREATE DATABASE dbname CHARACTER SET utf8;
GRANT ALL ON dbname.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;