备份数据库: mysqldump -uzkteco -p -h hfszdbvip -B --single-transaction zkteco>~/backupMysql/20170120zkteco.sql
备份数据库某个表 mysqldump -uzkteco -p -h hfszdbvip -B zkteco--single-transaction --table t_organ_wallet >~/backup/20170006hfepay_t_organ_wallet.sql
还原备份文件: mysql -uroot -p -h 172.16.2.100 zkteco<20170215zkteco.sql
grant select,insert,update,delete,create on `zkteco`.* to 'zkteco'@'%' identified by 'client205@@#@@';
grant all on `zkteco`.* to 'zkteco'@'%' identified by 'admin@admin';
grant select on `zkteco`.* to 'zkteco'@'%' identified by '123456';
flush privileges;
show processlist