Mysql 创建查询用户

GRANT USAGE ON *.* TO 'zjzc_zyj'@'%' identified by '1234567';

GRANT SELECT ON `zjzc`.* TO 'zjzc_zyj'@'%';

mysql> create table a100(id int);
ERROR 1142 (42000): CREATE command denied to user 'zjzc_zyj'@'localhost' for table 'a100'
mysql> delete from ActivityInfo;
ERROR 1142 (42000): DELETE command denied to user 'zjzc_zyj'@'localhost' for table 'ActivityInfo'

mysql> show grants for zjzc_zyj@'%';
+--------------------------------------------+
| Grants for zjzc_zyj@%                      |
+--------------------------------------------+
| GRANT USAGE ON *.* TO 'zjzc_zyj'@'%'       |
| GRANT SELECT ON `zjzc`.* TO 'zjzc_zyj'@'%' |
+--------------------------------------------+
2 rows in set (0.00 sec)

mysql>