Linux 備忘筆記 (1)

Linux 備忘筆記

1. 搜尋/var/log/secure，找出login root fail的IP
• cat /var/log/secure |grep 'Failed password for root from' |awk '{print $11}' |uniq -c |sort -n
2. mysql的transaction log file: mysql-bin.xxxxx 刪除方式：
• mysql> show binary logs; 
• mysql> purge binary logs to 'ablelee.000003';