mysql 函数执行权限

最新推荐文章于 2025-06-25 00:07:25 发布

原创最新推荐文章于 2025-06-25 00:07:25 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

本文深入探讨了MySQL中用户'query_all'的权限配置问题，详细解析了不同权限设置下执行函数的具体表现，包括权限不足导致的错误及解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.youkuaiyun.com/jiangjunshow