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>