While adding a routine from cPanel > PHPMyAdmin, I was getting this error message –
#1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation
First check if event scheduler is enabled on the server:
SHOW VARIABLES
WHERE VARIABLE_NAME = 'event_scheduler'If it is not enabled, enable it from SQL:
SET GLOBAL event_scheduler = ON;and to make it permanent, edit my.cnf
nano /etc/my.cnfAdd:
event_scheduler = 1Save the file and restart mysql.
service mysqld restart
![2023 08 28 12 15 344x194 - node[175421]: pthread_create: Resource temporarily unavailable](https://pcx3.com/wp-content/uploads/2023/08/2023-08-28_12-15-344x194.png "node[175421]: pthread_create: Resource temporarily unavailable")