I do not believe that is actually the case. MySQL has no concept of triggering on a time of day (which is to say, scheduling). If you want something to happen at 10:00 PM, you need to use whatever...

MySQL has an involved permissioning system that can take some getting used to. Their documentation (http://dev.mysql.com/doc/refman/5.0/en/grant.html) is, naturally, the best place to start.
...

You should mark the thread solved so people don't waste time on it.

No. You'll need a simple script to do this in PHP or whatever language you're going to be using on top of MySQL.