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 // 모두가능
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 // 모두가능
|