mysql5.6数据库备份及授权

备份数据库： 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