mysql

[mysql] remote 접근 허용하기

App.SHIN 2018. 1. 18. 02:39

use mysql;

GRANT ALL ON *.* to root@'%' IDENTIFIED BY '패스워드';

flush privileges;


my.cnf

[mysqld]

bind-address=127.0.0.1  //로컬에서만 접근가능

bind-address=IP         // ip로접근가능


#bind-address // 모두가능