常用命令 （实时更新）

CREATE DATABASE IF NOT EXISTS xxx default charset utf8 COLLATE utf8_general_ci;
sudo ufw status

sudo ufw allow from 192.168.112.100

netstat -an | grep SYN | awk '{print $5}' | awk -F: '{print $1}' | sort | uniq -c | sort -nr | more

route add -net 10.77.78.0 netmask 255.255.255.0 gw 10.77.50.1

grant all privileges on db_hejian.* to 'hjweb'@'%' Identified by 'hjweb@2014' WITH GRANT OPTION;

update mysql.user set password=PASSWORD('aaa@111') where User='root';

insert into mysql.user(Host,User,Password) values("localhost","jiehuan",password("12345"));

grant all privileges on db_hejian.* to 'jiehuan'@'%' Identified by '12345' WITH GRANT OPTION;

flush privileges;