mysql 函数执行权限

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.youkuaiyun.com/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

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'@'%';此时 可以执行函数,可以看到函数名,但是看不到函数内容

           

给我老师的人工智能教程打call！http://blog.youkuaiyun.com/jiangjunshow