MySQL/MariaDB create database and user

GOAL

MySQL / MariaDB でデータベースの作成とユーザの作成

Creating a database and user in MySQL / MariaDB

ENVIRONMENT

• MySQL 5.5+
• MariaDB 10.3+

PARAMETER

database name

PARAM_01:

user name

PARAM_02:

user password

PARAM_03:

host name

PARAM_04:

CODE

create database

CREATE DATABASE [PARAM_01] CHARACTER SET utf8mb4;

create user

CREATE USER [PARAM_02] IDENTIFIED BY password('[PARAM_03]');

grant user

GRANT ALL ON [PARAM_01].* to '[PARAM_02]'@'%';
GRANT ALL ON [PARAM_01].* to '[PARAM_02]'@'localhost';

grant user with host name

GRANT ALL ON [PARAM_01].* to '[PARAM_02]'@'[PARAM_04]';