grant select on xoms_prod.* to 'kzcf'@'%' identified by 'Kz!123456';
赋权
多权限就 grant select,update,delete on xoms.....
flush privileges;
然后这个语句保存权限
show grants for kzcf; kzcf就是用户名
那个 %号表示所有机器都能访问
==================在navicat-SQL执行界面,执行下面这条SQL语句
GRANT Select ON *.* TO reader@"%" IDENTIFIED BY "fotireader"
mysql linux 冷备份数据库脚本
mysqldump -uroot -ptingtong.123 --databases xwms > /home/ttx/bin/sqldumps/xwms-`date +"%Y%m%d_%H%M%S"`.sql