On the third day of security, iptables prevents nmap scanning and binlog

Turn on binlog Log function

  Create a table to back up the table

Backup data   No report error

  Insert a set of data

  Modify two sets of data

Delete database

Back up the last binlog Log files

  Then perform a refresh log index operation , Start a new binlog Log files . Logically speaking mysql-bin.000004  This file will not be written later , Because it is convenient for us to analyze the causes and find out ops node , In the future, all database operations will be written to the next log file .

  Recover database

 mysqlbinlog mysqlbin.000004 Analyze which sentence went wrong

Delete drop databaes xiaoyu This command

  Restore to the original data of the deleted database

Recover according to location  

First restore to the table before data change

View the location when changing

  Change to zhangsan The location of

  To complete the task

stay Iptables Configuring these commands on can effectively prevent nmap scanning

[[email protected] ]# iptables -t filter -I INPUT -p tcp --tcp-flags ALL FIN,URG,PSH -j REJECT
[[email protected] ]# iptables -t filter -I INPUT -p tcp --tcp-flags SYN,RST SYN,RST -j REJECT
[[email protected] ]# iptables -t filter -I INPUT -p tcp --tcp-flags SYN,FIN SYN,FIN -j REJECT
[[email protected] ]# iptables -t filter -I INPUT -p tcp --tcp-flags ALL SYN -j REJECT
[[email protected] ]# iptables -t filter -R INPUT 1 -s 192.168.80.138 -p tcp --dport 1: --tcp-flags ALL ACK -j REJECT