mariadb 원격접속

참조 : http://www.talkdev.net/mariadb-%EC%9B%90%EA%B2%A9-%EC%A0%91%EC%86%8D-%ED%97%88%EC%9A%A9/

에러 내용

Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MariaDB server

# 데이터베이스 생성

MariaDB [(none)]> create database {데이터베이스명};

Query OK, 1 row affected (0.00 sec)

 

 

# 사용자 등록

MariaDB [(none)]> insert into user (host, user, password) values('%', '{아이디}', password('{패스워드}'));

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges;

Query OK, 0 rows affected (0.00 sec)

 

 

# 외부 접속 허용 (모든 아이피에 대해서)

MariaDB [(none)]> grant all privileges on {데이터베이스명}.* to {아이디}@'%' identified by '{패스워드}' with grant option;

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges;

Query OK, 0 rows affected (0.00 sec)