SELECT host, user FROM user;

모든 IP 허용

GRANT

GRANT ALL PRIVILEGES ON . TO ‘아이디’@’%’ IDENTIFIED BY ‘패스워드’;

FLUSH PRIVILEGES;

INSERT

INSERT INTO mysql.user (host,user,password,ssl_cipher, x509_issuer, x509_subject) VALUES ('%','아이디',password('패스워드'),'','',''); GRANT ALL PRIVILEGES ON . TO '아이디'@'%'; FLUSH PRIVILEGES;

IP 대역 허용 (192.168.x.x)

GRANT

GRANT ALL PRIVILEGES ON . TO '아이디'@'192.168.%' IDENTIFIED BY '패스워드';

FLUSH PRIVILEGES;

INSERT

INSERT INTO mysql.user (host,user,password,ssl_cipher, x509_issuer, x509_subject) VALUES ('111.222.%','아이디',password('패스워드'),'','',''); GRANT ALL PRIVILEGES ON . TO '아이디'@'192.168.%'; FLUSH PRIVILEGES;