How Do I Stop phpmyadmin Event Scheduler From Turning Off in Restart Using WHM?

Operating System & Version
CENTOS 7.9
cPanel & WHM Version
94.0.4

PostAlmostAnything

Active Member
Mar 3, 2020
33
0
6
Portland, Oregon
cPanel Access Level
Website Owner
I have a problem in which I turn on my event scheduler using phpmyadmin as the root user by setting the global event scheduler variable to "on" either by flipping the little event scheduler switch to on or by finding the variable in the variables section and changing it to on. The problem is that whenever my server is restarted for any reason the event scheduler is turned off.

I have searched the internet and found situations in which people with similar problems say to edit a file called my.ini or my.cnf (How to set global event_scheduler=ON even if MySQL is restarted?). They say it is located someplace called etc/mysql/ but I can find so such file when I open the etc folder in file manager for any of my cpanel accounts, so I think it must be something only the root user can access, but WHM does not have a file manager, so I know of no way to edit that file via WHM.

This lack of a WHM file manager is a huge problem for anyone using a remote host because I cannot simply turn on a computer, click on some desktop icons, and find the file.
 
Last edited by a moderator: