mysql

MySQL Events

MySQL,

Display events – select database show events Dispaly events from information schema select * from information_schema.events Disable/Enable event ALTER EVENT myevent DISABLE; ALTER EVENT myevent ENABLE; https://dev.mysql.com/doc/refman/5.7/en/show-events.htmlhttps://dev.mysql.com/doc/refman/8.0/en/alter-event.html

MySQL Config Editor

MySQL,

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