SHUTDOWN command shuts the server down.
The following example shows how to create an event which turns off the server at a certain time:
CREATE EVENT `test`.`shutd` ON SCHEDULE EVERY 1 DAY STARTS '2014-01-01 20:00:00' COMMENT 'Shutdown Maria when the office is closed' DO BEGIN SHUTDOWN; END;
Other ways to stop mysqld
You can use the mysqladmin shutdown command to take down mysqld nicely.
You can also use the system kill command on Unix with signal SIGTERM (15)
kill -SIGTERM pid-of-mysqld-process
You can find the process number of the server process in the file that ends with
.pid in your data directory.
The above is identical to
On windows you should use:
NET STOP MySQL