MySQL 외부 접속 설정 방법

MySQL 외부 접속 설정 방법입니다.

 

 

1) mysql DB 선택

mysql> use mysql

 

 

2) 외부 접속 허용 쿼리 추가

mysql> grant all privileges on DB명.* to 계정명@’원격IP’ identified by ‘패스워드’ with grant option;

ex) grant all privileges on *.* to ‘root’@’xxx.xxx.xxx.xxx’ identified by ‘password’ with grant option;

 

 

3) 설정 저장

mysql> flush privileges;

 

 

No comments
Write CommentLIST
WRITE COMMENT

This site uses Akismet to reduce spam. Learn how your comment data is processed.

위로이동