[상태확인]

1. root 계정의 host 를 알수있음.

SELECT Host FROM mysql.USER WHERE USER='root';

INSERT INTO mysql.USER (host,USER,password) VALUES ('%','root',password('패스워드'));
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;

INSERT INTO mysql.USER (host,USER,password) VALUES ('111.222.%','root',password('패스워드'));
GRANT ALL PRIVILEGES ON *.* TO 'root'@'111.222.%';
FLUSH PRIVILEGES;

3. 특정 IP만 허용

INSERT INTO mysql.USER (host,USER,password) VALUES ('111.222.%','root',password('패스워드'));
GRANT ALL PRIVILEGES ON *.* TO 'root'@'111.222.%';
FLUSH PRIVILEGES;

DELETE FROM mysql.USER WHERE Host='%' AND USER='root';
FLUSH PRIVILEGES;

이상.