event scheduler won't turn on (mysql)

Question

When I tried this code:

SHOW GRANTS FOR 'secret'@'localhost';

this is the result:

Grants for secret@localhost
GRANT USAGE ON *.* TO 'secret'@'localhost' IDENTIFIED BY PASSWORD 'secretpass'
GRANT ALL PRIVILEGES ON `secret\_dbx`.* TO 'secret'@'localhost'
GRANT ALL PRIVILEGES ON `secret\_db1x`.* TO 'secret'@'localhost'

But when i want to set the event_scheduler on

SET GLOBAL event_scheduler = "ON"

this error show :

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

then tried this code :

 GRANT SUPER ON *.* TO secret@'localhost' IDENTIFIED BY 'secretpass';
 FLUSH PRIVILEGES;

And then the error:

 Access denied for user 'secret'@'localhost' (using password: YES)

I know I'm using root , I used the username and password to access the control panel of my domain.

Try `SELECT USER();`. What does it return? You most likely aren't root and don't have sufficient privileges. — danronmoon, Jul 27 '14 at 07:53
USER() username@localhost 1 return .. but i got 3 users .... hmmmm .... and that username@localhost stand for my username in my controlpanel — hordan mich el, Jul 27 '14 at 07:59
Is it possible then that you've granted the SUPER permission to the wrong user? — Álvaro González, Jul 27 '14 at 16:46
checked the other 2 user ... both doesn't have full privileges .... — hordan mich el, Jul 27 '14 at 16:52

score 0 · Answer 1 · edited May 23 '17 at 12:33

0

Check this docs. All the permissions are given here.

I think you need to code like:

CREATE USER 'secret_user@localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'secret_user@localhost';
FLUSH PRIVILEGES;

For more information check here.

edited May 23 '17 at 12:33

Community

1
1

answered Jul 27 '14 at 03:43

Avinash Babu

6,171
3
21
26

tried that and then error Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation – hordan mich el Jul 27 '14 at 03:50

score -2 · Answer 2 · answered Jul 27 '14 at 17:00

-2

found the answer ... and sadly I have to work on cron jobs because i shared a hosting ... now I hate re-seller hosting

answered Jul 27 '14 at 17:00

hordan mich el

29
6

What's the answer you found? – danronmoon Jul 27 '14 at 18:46

event scheduler won't turn on (mysql)

2 Answers2