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