How Do I Stop phpmyadmin Event Scheduler From Turning Off in Restart Using WHM?
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 (
-
If you do not have root-level access to the server then it is best to contact your hosting provider. 0 -
As usual, @kodeslogic is correct - without root access to the machine you would not be able to check or make any modifications to those files you mention. You'd have to reach out to your hosting provider or datacenter to have them check that issue for you. 0 -
Just bringing this back up because I have the same issue, and I do have root access, I also use configServer Explorer as a file manager, and I cannot find the files referenced abover either (either my.ini, cnf.ini or mysqld.conf) I noticed my scheduler was disabled yesterday, re-enabled it and it's off again this morning, although my server hasn't even been restarted. How can I get this to stay on? 0 -
@adeyjones - the configuration file on a cPanel server is /etc/my.cnf You'd want to use the following format in that file: event_scheduler=ON
and then restart the MySQL service after making that change to load the new configuration.0
Please sign in to leave a comment.
Comments
4 comments