Mysql read-only 계정 설정

1. root 계정으로 mysql 접속

CREATE USER '{id}'@'%' IDENTIFIED BY '{password}';

CREATE USER 'read_only'@'%' IDENTIFIED BY 'pw1234';
GRANT SELECT ON DB1.* TO 'read_only'@'%';
GRANT SELECT ON DB2.* TO 'read_only'@'%';
GRANT SELECT ON DB3.* TO 'read_only'@'%';
FLUSH PRIVILEGES;

 

2. 방화벽 오픈

iptables -A INPUT -s 2**.***.**.**6 -p tcp --dport 3306 -j ACCEPT