MySQL

重置密碼

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('')

• Reset a MySQL root password

備份

mysqldump -h hostname -u username -p mydatabase > mydatabase.sql

• Backup Your MySQL Databases Manually With Mysqldump

建立帳號

mysql -e "CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'mypassword'; GRANT ALL PRIVILEGES ON . TO 'newuser'@'localhost'; FLUSH PRIVILEGES;" -u root -p

插入

INSERT INTO mydata (uuid, mynumber) VALUES ('275fb8566bcb11e69d34025fb2f1683d', 42);

Event

SET GLOBAL event_scheduler = ON;

CREATE EVENT
  clear_executed_command
ON SCHEDULE EVERY 5 SECOND
DO
  DELETE FROM command_queue WHERE mynumber = 42;

DROP EVENT clear_executed_command;

參考