Windows server服务器mysql备份批处理

创建mysql.bat

echo ry_prod backup is starting...
set filename=D:\bim\bak\db\ry_prod\ry_prod%date:~0,4%-%date:~5,2%-%date:~8,2%_%time:~0,2%%time:~3,2%%time:~6,2%.sql
echo %filename%
mysqldump --default-character-set=utf8 -h 10.32.8.48 -ury_prod -p123456 ry_prod>%filename%
echo finish backup!
pause

执行bat文件,提示如下信息

‘Access denied； you need (at least one of) the PROCESS privilege(s) for this operation‘ when trying

缺少PROCESS权限

GRANT PROCESS ON *.* TO 'ry_prod'@'%';
 
flush privileges;

再次执行备份数据库脚本