[MariaDB, MySQL] How to create new database.

This is the manual how to create new database for developing on ZTI database server.

1. Remote to ZTI database server.
   
2. Login to mariadb
   $ mysql -u root -p
   
3. Create new database with command
   > create database <db_name>;
   > create user ‘<username>‘@’localhost’ identified by ‘<password>‘;
   > create user ‘<username>‘@’%’ identified by ‘<password>‘;
   > grant all on <db_name>.* to ‘<username>‘ identified by ‘<password>‘;
   > flush privileges;
   > exit
   
   * replace <db_name>, <username>, <password>.
   
4. Default configuration:
   Character set: utf8mb3 — UTF-8 Unicode
   Collation: utf8mb3_general_ci

database mariadb mysql