grant 权限的时候一定要注意 实体名称不要写错，同时查看的结果是不区分大小写的。

mysql> grant execute on procedure schoolDB.addStudent to ‘zhang’@‘192.168.231.%’;
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for ‘zhang’@‘192.168.231.%’;
±-----------------------------------------------------------------------------------------------------------------+
| Grants for zhang@192.168.231.% |
±-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON . TO ‘zhang’@‘192.168.231.%’ IDENTIFIED BY PASSWORD ‘*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B’ |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON schoolDB.TStudent TO ‘zhang’@‘192.168.231.%’ |
| GRANT EXECUTE ON PROCEDURE schoolDB.addstudent TO ‘zhang’@‘192.168.231.%’ |
| GRANT EXECUTE ON PROCEDURE schoolDB.getmax TO ‘zhang’@‘192.168.231.%’ |
| GRANT EXECUTE ON PROCEDURE schoolDB.gets TO ‘zhang’@‘192.168.231.%’ |
±-----------------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)

请注意，在grant 语句中 addStudent 是明确了大写的，
但在 查看 show grant 的时候， addstudent却是小写的。
所以，通过此例，在grant 的时候，一定要注意不要写错，否则查找起来非常的费劲。

January the 29th 2022 Saturday