MYSQLで ReadOnly なユーザの作りかた
GRANT SELECT ON *.* TO readonly@"%" IDENTIFIED BY ""; GRANT SELECT ON *.* TO readonly@"localhost" IDENTIFIED BY ""; GRANT SELECT ON *.* TO readonly@"10.0.%.%" IDENTIFIED BY ""; GRANT SELECT ON *.* TO readonly@"192.168.%.%" IDENTIFIED BY ""; FLUSH PRIVILEGES;