1.给root账户授权所有sql权限grantallprivilegeson*.*toroot@"%"identifiedby".";flushprivileges;2.建立bat批处理文件@echooff
setpath=%path%;D:ProgramFilesMySQLMySQLServer5.5bin
sety=%date:~0,4%
setm=%date:~5,2%
setd=%date:~8,2%
seth=%time:~0,2%
setcdate=%y%%m%%d%_%h%
mysqldum