mariadb 계정 추가및 DB권한 부여

use mysql;

-- 계정생성 및 접근 범위 설정. %=모든IP, 192.168.10.% = 해당IP대역
CREATE USER '계정'%' IDENTIFIED BY '비밀번호';

-- 해당계정에 대한 특정DB 모든권한
GRANT ALL PRIVILEGES ON DB명.* to '계정@'%';

-- 변경사항 적용
flush privileges;

예)

MariaDB [mysql]> create database test;
Query OK, 1 row affected (0.001 sec)

MariaDB [mysql]> create user 'graykang'@'%' identified by '********';
Query OK, 0 rows affected (0.007 sec)

MariaDB [mysql]> grant all privileges on test.* to 'graykang'@'%';
Query OK, 0 rows affected (0.007 sec)

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.001 sec)

MariaDB [mysql]>