1
I’m trying to activate the events of mysql
5.7, but I get an error.
To:
SET GLOBAL event_scheduler = ON;
I get:
01:16:06 SET GLOBAL event_scheduler = ON Error Code: 1227. Access denied; you need (at least one of) the SUPER Privilege(s) for this Operation 0.057 sec
In the documentation says it’s necessary to change the privileges, but I tried with:
GRANT EVENT ON *.* TO user;
But it does not affect any line, and continues the same initial error (you need SUPER...) when I try to activate.
I’ve also edited the file my.cfn
(which would be ideal) and includes within the [mysqld], as indicated in this and in other articles:
[mysqld]
event_scheduler = ON;
But it doesn’t change anything. Any ideas?