MySQL events_schedule='ON' fails due to privileges

Question

I’m trying to turn events on. If I execute SET GLOBAL event_schedule="ON" , MySQL gives me this error:

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

I’m using the root user of my WHM and open cPanel of one of the accounts I have.

The error is telling you exactly what the problem is. Grant the user `SUPER` privilege. — miken32, Dec 23 '15 at 23:18
i know what it says my friend i am logged in with server root user , then what more super than root user ? — Alaa M. Jaddou, Dec 23 '15 at 23:19
that was my question why it telling me this while i'm the root ? — Alaa M. Jaddou, Dec 23 '15 at 23:20

score 6 · Accepted Answer · edited May 23 '17 at 11:44

6

There is a difference between Server Root and MySql User Privileges. You need to give yourself MySql privileges. See MySQL: Grant **all** privileges on database

edited May 23 '17 at 11:44

Community

answered Dec 24 '15 at 01:08

nathan hayfield

you mean i need to give the cpanel root which has the very high privileges grant all ? – Alaa M. Jaddou Dec 24 '15 at 01:09
@AlaaM.Jaddou no you need to give the privileges to the database user. You need to run a query to do that. – nathan hayfield Dec 24 '15 at 01:10
when i'm using server root then i got all the privileges in everything in the server man – Alaa M. Jaddou Dec 24 '15 at 01:10
i used to do that with current user in other accounts in the same server :( – Alaa M. Jaddou Dec 24 '15 at 01:11
how can i check the privileges to this user ? – Alaa M. Jaddou Dec 24 '15 at 01:11
1

added another link with many queries you can run about users and permissions – nathan hayfield Dec 24 '15 at 01:13

1 Answers1