假设你的只读用户是’app_ro’@’%’，则授权语句为：

GRANT SELECT, SHOW VIEW  ON `oadb`.* TO 'app_ro'@'%';
复制

假设你的读写用户是’app_wr’@’%’，则授权语句为：

GRANT ALTER, CREATE, DELETE, DROP, INDEX, INSERT, UPDATE, TRIGGER, REFERENCES, EVENT, CREATE VIEW, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE  ON `app_ro`.* TO 'app_wr'@'%';
复制