写了一个本地/远程MySQL批量添加用户的Shell脚本-CSDN博客

MySQL批量添加用户的Shell脚本，可以本地MySQL添加，也可是远程MySQL数据库服务器

代码如下：

#!/bin/bash
_db="$1"
_user="$2"
_pass="$3"
_dbremotehost="$4"
_dbrights="$5"
## Path to mysql bins ##
mysql="/usr/bin/mysql"
## Mysql root settings ##
_madminuser='root'
_madminpwd='MySQL-PassWord'
_mhost='localhost'
# make sure we get at least 3 args, else die
[[ $# -le 2 ]] && { echo "Usage: $0 'DB_Name' 'DB_USER' 'DB_PASSORD' ['remote1|remote2|remoteN'] ['DB_RIGHTS']"; exit 1; }
# fallback to ALL rights
[[ -z "${_dbrights}" ]] && _dbrights="ALL"
# build mysql queries
_uamq="${mysql} -u "${_madminuser}" -h "${_mhost}" -p'${_madminpwd}' -e 'CREATE DATABASE ${_db};'"
_upermq1="${mysql} -u "${_madminuser}" -h "${_mhost}" -p'${_madminpwd}' -e /"GRANT ${_dbrights} ON ${_db}.* TO ${_user}@localhost IDENTIFIED BY '${_pass}';/""
# run mysql queries
$_uamq
$_upermq1
# read remote host ip in a bash loop
# build queires to grant permission to all remote webserver or hosts via ip using the same username
IFS='|'
for i in ${_dbremotehost}
do
_upermq2="${mysql} -u "${_madminuser}" -h "${_mhost}" -p'${_madminpwd}' -e /"GRANT ${_dbrights} ON ${_db}.* TO ${_user}@${i} IDENTIFIED BY '${_pass}';/""
$_upermq2
done

复制代码

使用时先把代码存入名为 addmysqlusers.sh 的脚本文件里，
#chmod +x addmysqlusers.sh

本地批量添加：
./addmysqlusers.sh bar tom jerry

远程批量添加，多个远程服务器用 | 隔开：
./addmysqlusers.sh bar tom jerry '192.168.1.5|192.168.1.11'