Linux shell: mysql bin_log regular cleanup script

Linux shell: mysql bin_log regular cleanup script
Requirement: 1. automatically process mysql bin log Script 2. Output readable log3, retain logs for one week 4. process all databases in a unified manner. Implementation Process description: Train of Thought: two ways to achieve 1. mysql directory obtains the bin log directory through ls and deletes it by command. 2. Run the mysql command to obtain the bin log and delete it. In comparison, the second method is easier to implement. Function statement: mysql-h192.168.1.2-uroot-pXXXXX