I am trying to create a reccurring event that should occur every day and with no end date. So I went with:
CREATE DEFINER=`xxx`@`xxx` EVENT `my_event` ON SCHEDULE EVERY 1 DAY STARTS '2016-08-23 08:00:00' ON COMPLETION PRESERVE ENABLE DO TRUNCATE TABLE `my_table`
preserve on completion
Ok, I think that I found here the solution to my problem.
The version in this link is not the same as mine. With the current version it seems that I have to put
at the bottom of the [mysqld] section of the file
After reboot, it is working.