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;