CREATE DATABASE IF NOT EXISTS xxx default charset utf8 COLLATE utf8_general_ci;
sudo ufw status
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;