MySQL数据备份

#!/bin/bash
my_user='数据库用户名'
my_pass='数据库密码'
my_host='IP地址'
my_conn="-u $my_user -p $my_pass -h $my_host" #数据库备份命令
my_db1="库名"
my_db2.....
bf_dir="/back"
bf_cmd="/usr/bin/mysqldump"
bf_time='date +%Ym%d-%H%M'
name_1='$my_db1-$bf_time'
name_2='$my_db2-$bf_time'
cd $bf_dir
$bf_cmd $my_conn --databases $my_db1 > name_1.sql
$bf_cmd $my_conn --databases $my_db2 > name_2.sql
/bin/tar zcf $name_1.tar.gz $name_1.sql --removr & > /dev/null
/bin/tar zcf $name_2.tar.gz $name_2.sql --removr & > /dev/null

alter user user() identified by "XXXXXX";
SHOW VARIABLES LIKE 'validate_password%';