Can you activate event_scheduler in MariaDB?

Den här artikeln finns även på: Svenska

Due to security concerns, we cannot activate event_scheduler in MariaDB on our web hosting account servers. Therefore, you cannot set up eventes in MariaDB.

Instead, we recommend that you use cron jobs set up on the server.

When you create the cron job, you could use a command like this:

mariadb -h localhost -u DATABASE_USER -p PASSSWORD -D DATABASE_NAME -e "QUERY"

It is wise to create a separate MariaDB user for this, and then connect that new user to the database. Remember to swap out DATABASE_USER, PASSWORD, DATABASE_NAME, and QUERY in the command above.

If you have no alternatives to running events directly via MariaDB, you need to set up a server via Oderland Cloud. There, you can set up MySQL (and other software) in any way you want. If you have a Managed Server, we can help you activate event_scheduler.