mysql #1045 - Access denied in online server for GRANT SUPER

Question

I have a online server with phpmyadmin. i want to use events, but i can't.

Answer 1

Ok, I had the same problem and I just fixed it. Try granting root permissions explicitly for the database you are using.

GRANT ALL PRIVILEGES ON ${database}.* TO 'root'@'localhost' IDENTIFIED BY '${pass}';