2

When I try to set:

SET GLOBAL event_scheduler=ON;

or

SET GLOBAL event_scheduler = 1;

I get:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So, I try this:

GRANT SUPER ON *.*
TO 'username'@'localhost' 
IDENTIFIED BY 'password';

and I get:

#1045 - Access denied for user 'username'@'localhost' (using password: YES)

How can I grant the SUPER priviledges?

Related questions:

How to set global event_scheduler=ON even if MySQL is restarted?

how to add super privileges to mysql database?

Community
  • 1
  • 1
Bzyzz
  • 173
  • 5
  • 15
  • does the account you're logged into mysql with have `grant` privileges? – Marc B Nov 05 '14 at 21:59
  • I clicked ALL PRIVILEGES and these are the ones that show up: ALTER, CREATE, CREATE TEMPORARY TABLES, DELETE, EVENT, INDEX, LOCK TABLES, SELECT, TRIGGER, ALTER ROUTINE, CREATE ROUTINE, CREATE VIEW, DROP, EXECUTE, INSERT, REFERENCES, SHOW VIEW, UPDATE, – Bzyzz Nov 05 '14 at 22:33
  • irrelevant. the account you're logged into must have the `WITH GRANT` option. That's a META-privilege - the ability to assign privileges to others. – Marc B Nov 06 '14 at 14:03

1 Answers1

0

First, to change the value of the global event_scheduler system variable you need SUPER privileges... and that and only that account with that privileges can change it... it's impossible if you don't have that privilege.

Try GRANT EVENT ON [myschema].* TO [username]@[localhost];

Gerardo Charles Rojas Vega
  • 633
  • 7
  • 16