I'm still kind of new to MySQL as I've only used the most basic functions and I've only been getting more overwhelmed as I get into the more impressive sides of it. I decided to make a scheduler event and I screwed up. I put a space in the name. I've tried renaming it, but it doesn't seem to be able to read it.
ALTER EVENT 'update bills'
RENAME TO 'update_bills';
Do it like this way:
Alter EVENT `update bills` Rename To update_bills;
This char `` mysql need in any case to make your query construction DB Readable.
This is 100% working, Hope it helps