欲创建一个触发器,在表mysql.user 被update 之后,执行flush privileges ,请教过路高人怎么写?
0 updateç¨æ¥æ´æ¹mysql.user表çæ¹å¼ï¼å
¶å®ä¸æ¯æ¨èæ¹å¼ï¼å 为ä¸ä¼å¯¹å·²ç»å½çç¨æ·çæï¼åªå½±åå°ä¸æ¬¡ç»å½çç¨æ·ï¼æ¨è使ç¨grantï¼ æ set passwordï¼ ædrop userç¶åcreate useræ¹å¼æ¥æ´æ°ç¨æ·ï¼è¿å 个æ¹å¼é½ä¼èªå¨å·æ°ç¨æ·æéå°å
åä¸ï¼å³ç¸å½äºè°ç¨äºflush privilegesï¼ï¼
1 æä¾ä¸ªè§¦åå¨çdemoï¼æªæµè¯ï¼éåèï¼
delimiter ||
drop trigger if exists abc; ||
CREATE TRIGGER abc AFTER UPDATE ON mysql.user
FOR EACH ROW
BEGIN
flush privileges;
END;
||
delimiter ;
1 æä¾ä¸ªè§¦åå¨çdemoï¼æªæµè¯ï¼éåèï¼
delimiter ||
drop trigger if exists abc; ||
CREATE TRIGGER abc AFTER UPDATE ON mysql.user
FOR EACH ROW
BEGIN
flush privileges;
END;
||
delimiter ;
温馨提示:答案为网友推荐,仅供参考
第1个回答 2013-03-27
第一步修改结束符
delimiter //
第二步
create trigger abc after update on mysql.user for each row
begin
flush privileges
end//
delimiter //
第二步
create trigger abc after update on mysql.user for each row
begin
flush privileges
end//