1、grant create,update,delete on testdb.*to testdb_admin@'%'identity by 'newpassword';
2、grant select,insert,update,delete on testdb.* to testdb_wirte@'%' identity by 'newpassword';
3、grant testdb.*to testdb_writer@'%;' identity by 'newpassword';
1
grant create,update,delete on testdb.* to testdb_admin@'%' identified by 'yourpassword';
2
grant select,insert,update,delete on testdb.* to testdb_writer@'%' identified by 'yourpassword';
3
grant select testdb.* to testdb_writer@'%' identified by 'yourpassword';