MySQL R/RW User Template

mysql_users_template.sql

GRANT SELECT, CREATE TEMPORARY TABLES ON DATABASE_NAME.* TO `DATABASE_NAME_r`@"192.168.%" IDENTIFIED BY '';
GRANT PROCESS ,SHOW DATABASES ON *.* TO `DATABASE_NAME_r`@"192.168.%" IDENTIFIED BY '';

GRANT ALTER, DELETE, INDEX, INSERT, SELECT ,UPDATE ,CREATE, DROP, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW ON `DATABASE_NAME`.* TO `DATABASE_NAME_rw`@"192.168.%" IDENTIFIED BY 'XXXXXXXXX';
GRANT PROCESS ,SHOW DATABASES ON *.* TO `DATABASE_NAME_rw`@"192.168.%" IDENTIFIED BY 'XXXXXXXXXX';

FLUSH PRIVILEGES;

192.168.% とかなってるのは適宜変更する。
あと、パスワード無しがアレだったら適宜アレする。