How to enable events in mysql 5.7?

Asked

Viewed 105 times

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?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.