MySQL Events

Display events – select database show events Dispaly events from information schema select * from Disable/Enable event ALTER EVENT myevent DISABLE; ALTER EVENT myevent ENABLE;

MySQL Config Editor

Use MySQL Config editor to save your login cridential and use it in any scripting. Create login-path mysql_config_editor set –login-path=LOGIN-PATH-NAME–user=USERNAME–socket=/tmp/mysql3340.sock -p mysql_config_editor set –login-path=LOGIN-PATH-NAME–user=USERNAME–host=HOSTNAME –port=PORT -p