Environment:
CentOS / Redhat 5
MySQL 5.1Grant Statement:
CREATE PROCEDURE getALLGF ...;
GRANT EXECUTE ON PROCEDURE getAllGF to 'User1'@'%';mysql.procs_priv: seems normal
...User1 ... getAllGF ... Execute ...SHOW GRANTS FOR User1: lower case !!???
...Execute on getallgf ...To User1 ...Execute by User1:
1. CALL getAllGF: No permissions
2. CALL getallgf: The procedure does NOT exist.
CentOS / Redhat 5
MySQL 5.1Grant Statement:
CREATE PROCEDURE getALLGF ...;
GRANT EXECUTE ON PROCEDURE getAllGF to 'User1'@'%';mysql.procs_priv: seems normal
...User1 ... getAllGF ... Execute ...SHOW GRANTS FOR User1: lower case !!???
...Execute on getallgf ...To User1 ...Execute by User1:
1. CALL getAllGF: No permissions
2. CALL getallgf: The procedure does NOT exist.
解决方案 »
- mysql查询性能的问题,比较奇怪
- 怎么导出数据库结构?
- CMD每隔5分钟判断mysql是否正常,不正常则net stop mysql,再net start mysql,怎么写,谢谢!
- 300 分一个问题.
- 查找表中记录总条数的SQL语句处理问题
- linux下如何启动mysql
- 请教各位大师,开启InnoDB engine 后,mysql4.1-max无法启动,另mysql的log文件在什么地方
- 怎么没有这个工具MySQLManager.exe?????
- MYSQL 在网页上输入的是数字 但是进到phpmyadmin里面
- mysql中COUNT(*)与2次GROUP BY问题
- 多层的数据库设计
- 数据库有几个啊
可以贴出你的以下信息,不要加工。直接贴就行了。show grants;
CALL getAllGF();
CALL getallgf();
show procedure status;