你说的是root吗?用它进入后,能显示和进入所有的数据库。GRANT ALL ON ce.* TO 'abcu'@'%' IDENTIFIED BY "12345678P"这个All不是才表所有权限吗?用这个abcu登录后,就不能显示和进入它的ce数据库。
delimiter $$ create procedure p1() SQL SECURITY INVOKER begin select id,website,content,url from po; end $$ delimiter ; 我后来修改了存储过程的权限。还是没办法运行存储过程。这是怎么回事?
show grants;看一下结果是什么?
我后来换了ce数据库为samp. 如下图。
用你的这个 abcu 进行,然后执行命令 show grants;show databases;另外建议你直接贴文本,不要贴图。mysql> show grants; +------------------------------------------------------------------------------- ---------------------------------------------------------+ | Grants for root@localhost | +------------------------------------------------------------------------------- ---------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*23A E809DDACAF96AF0FD78ED04B6A265E05AA257' WITH GRANT OPTION | +------------------------------------------------------------------------------- ---------------------------------------------------------+ 1 row in set (0.00 sec)mysql>
你说的是root吗?用它进入后,能显示和进入所有的数据库。GRANT ALL ON ce.* TO 'abcu'@'%' IDENTIFIED BY "12345678P"这个All不是才表所有权限吗?用这个abcu登录后,就不能显示和进入它的ce数据库。
create procedure p1()
SQL SECURITY INVOKER
begin
select id,website,content,url from po;
end $$
delimiter ;
我后来修改了存储过程的权限。还是没办法运行存储过程。这是怎么回事?
+-------------------------------------------------------------------------------
---------------------------------------------------------+
| Grants for root@localhost
|
+-------------------------------------------------------------------------------
---------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*23A
E809DDACAF96AF0FD78ED04B6A265E05AA257' WITH GRANT OPTION |
+-------------------------------------------------------------------------------
---------------------------------------------------------+
1 row in set (0.00 sec)mysql>