CODEWITHSUNDEEP
mysqldatabaseeventsscheduler
Smile Kisan
Smile Kisan

Reputation: 321

you need (at least one of) the SUPER privilege(s) in mysql (Live Server)

I am trying to create an event in the live server but i am getting this problem when setting the global event_scheduler on. Can anyone help to solve this problem??

enter image description here

Upvotes: 0

Views: 2274

Answers (1)

user10360146
user10360146

Reputation:

You can add super privilege using phpmyadmin:

Go to PHPMYADMIN > privileges > Edit User > Under Administrator tab Click SUPER. > Go

If you want to do it through Console, do like this:

 mysql> GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password';

After executing above code, end it with:

mysql> FLUSH PRIVILEGES;

You should do in on . because SUPER is not the privilege that applies just to one database, it's global.

You Can Read More Information Here

Upvotes: 1

Related Questions