mysql函数调用_mysql 函数执行权限

mysql> show grants for query_all@'115.236.1x0.x';

+-----------------------------------------------------------------------------------------------------------------------+

| Grants for query_all@115.236.1x0.x |

+-----------------------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'query_all'@'115.236.1x0.x' IDENTIFIED BY PASSWORD '*17167D048E538ED16DF5BD732EF9E1B2D9048F6E' |

| GRANT SELECT, EXECUTE ON `zjzc`.* TO 'query_all'@'115.236.1x0.x'

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

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

这样的权限情况下:

Error Code: 1370. execute command denied to user 'query_all'@'%' for routine 'zjzc.loadTreeByParent'

会权限不足,而且也看不到函数内容；

加上执行权限后:

GRANT SELECT , EXECUTE ON `zjzc`.* TO 'query_all'@'%';

此时 可以执行函数,可以看到函数名,但是看不到函数内容