0

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

Smile Kisan
  • 191
  • 4
  • 19

1 Answers1

1

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

  • Phpmyadmin is not showing the privileges section. And For granting via console i think i have to be the super user by default which i am not. – Smile Kisan Sep 20 '18 at 06:30
  • AS a user who doesn't have admin access can't add privileges. This would defeat the whole purpose of authentication/authorisation. You can reset the root password following the step outlined in this http://www.cyberciti.biz/tips/recover-mysql-root-password.html. For More inforation, Visit this link https://serverfault.com/questions/264170/adding-a-mysql-user-when-no-mysql-users-have-admin-rights –  Sep 20 '18 at 06:44