Mysql定时备份 Using a password on the command line interface can be insecure

最近运维过程中需要备份Mysql数据库，网上找bat脚本执行发现提示不能直接在脚本里放密码，Using a password on the command line interface can be insecure，应该是高级的mysql数据库的安全策略。

首先建一个bat文件 

?

1	--defaults-extra-file=D:\MySQLBackUp\my.ini，将原来的sql语句放到ini文件中

?

1 2 3 4 5 6 7 8 9 10 11

@echo off set hour=%time:~0,2% if "%time:~0,1%"==" " set hour=0%time:~1,1% set now=%Date:~0,4%%Date:~5,2%%Date:~8,2%%hour%%Time:~3,2%%Time:~6,2% echo %now%   set dbnamedhcp=dhcp_v2.1_gcp   set backupfiledhcp=D:\MySQLBackUp\Dhcp\%dbnamedhcp%-%now%.sql   "D:\mysql\mysql\bin\mysqldump" --defaults-extra-file=D:\MySQLBackUp\my.ini -c --add-drop-table %dbnamedhcp% > %backupfiledhcp%

然后创建一个my.ini文件，使用绝对路径，然后配置host账号密码，密码不可用带！等特殊字符，不然会登录不上

?

1 2 3 4

[client] host = localhost user = backup password = Backup1234@

然后在计划任务里，定时去跑bat就可以了