mysql给用户授予数据库的操作权限

75 阅读1分钟

mysql> grant select,insert,update,delete on cz_istester_com.* to istester@'%' identified by 'istester.com'; 

Query OK, 0 rows affected (0.00 sec) 

mysql> flush privileges; 

Query OK, 0 rows affected (0.00 sec)