如何开启数据库的函数，存储过程，事件。触发器功能？
1、sqlyog 用root权限登陆后，无法开启数据库的事件功能
2、4 queries executed, 0 success, 4 errors, 0 warnings
Query: SET GLOBAL event_scheduler = ON
Error Code: 1227
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.027 sec
-----------------------------------------------------------
Query: SET @@global.event_scheduler = ON
Error Code: 1227
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.025 sec
-----------------------------------------------------------
Query: SET GLOBAL event_scheduler = 1
Error Code: 1227
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.037 sec
-----------------------------------------------------------
Query: SET @@global.event_scheduler = 1
Error Code: 1227
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.030 sec
4、用root账号登陆
展开
收起
问答分类：
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
相关问答
问答排行榜
最热
最新
推荐问答
