mysql, 접속 허용설정

1. 모든 IP 허용
INSERT INTO mysql.user (host,user,password) VALUES ('%','root',password('패스워드'));
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;

2. IP 대역대 허용
INSERT INTO mysql.user (host,user,password) VALUES ('192.168.%','root',password('패스워드'));
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.%';
FLUSH PRIVILEGES;

3. 특정 IP 허용
INSERT INTO mysql.user (host,user,password) VALUES ('192.168.0.5','root',password('패스워드'));
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.5';
FLUSH PRIVILEGES;

4. 원상복귀
DELETE FROM mysql.user WHERE Host='%' AND User='root';
FLUSH PRIVILEGES;