[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