创建数据库用户
CREATE USER 'zmmysql'@'%' IDENTIFIED BY 'zmmysql_rw';
数据库用户只有读写权限:
GRANT SELECT, INSERT, UPDATE, DELETE ON doreader.* TO 'doreader_rw'@'%' IDENTIFIED BY 'doreader_rw_11';
数据库用户只有读权限:
GRANT SELECT ON doreader.* TO 'doreader_r'@'%' IDENTIFIED BY 'doreader_r_11';