execute command denied to user...

UDX创建用户时MySQL报以下错误:

execute command denied to user 'se_conn'@'%s' for routine 'kyp_db.TL_GETSERIAL'

 

解释与处理:

TL_GETSERIAL是以用户se_conn身份创建的:
CREATE DEFINER=`se_conn`@`%` PROCEDURE `TL_GETSERIAL`(_orgID LONG , _reqID LONG, OUT _Serial LONG)

而hotfox.conf的连接是以root用户访问数据库的.
必须授权,执行以下命令:

GRANT ALL PRIVILEGES ON *.* TO 'se_conn'@'%' ;
FLUSH PRIVILEGES;

相应的撤消权限命令:
REVOKE ALL PRIVILEGES ON *.* FROM  'se_conn'@'%' ;
FLUSH PRIVILEGES;