-- 函数、存储过程
select definer from mysql.proc;
update mysql.proc set definer=‘billing@%‘;
-- 定时事件
select DEFINER from mysql.EVENTS;
update mysql.EVENTS set definer=‘billing@%‘;
--视图
select DEFINER from information_schema.VIEWS;
select concat("alter DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW ",TABLE_SCHEMA,".",TABLE_NAME," as ",VIEW_DEFINITION,";") from information_schema.VIEWS where DEFINER<>‘billing@%‘;
--触发器
select DEFINER from information_schema.TRIGGERS;
mysql修改definer方法
原文：http://www.cnblogs.com/zejin2008/p/4741747.html
