Multi-instance MySQL bulk add users and passwords and authorize

Os:cent OS 6.3

db:5.5.14

If there are 100 MySQL DB instances on a server, you need to add a user name, password and authorization application IP to several databases of different ports, authorization is not a problem, anyway tired is not me, wow ka ka.


Create add_user.sh

#/bin/bash
#add user to MySQL DB


Passpwd= "Yoon"


Cat User.txt | While read user
Do
Port= ' echo $user |awk ' {print $} '
Username= ' echo $user |awk ' {print $} '
Pwd= ' echo $user |awk ' {print $} '
Db= ' echo $user |awk ' {print $4} '
# echo ' port= ' $port ', username= ' $username ';p wd= ' $pwd ';d b= ' $db


/export/servers/mysql/bin/mysql-s/export/data/mysql/tmp/mysql$port.sock-uroot-p$passpwd <<EOF


Use MySQL;


GRANT select,insert,update,delete on $db. * to ' $username ' @ ' 192.17.12.2 ' identified by ' $pwd ';
GRANT select,insert,update,delete on $db. * to ' $username ' @ ' 192.17.12.3 ' identified by ' $pwd ';
GRANT select,insert,update,delete on $db. * to ' $username ' @ ' 192.17.12.4 ' identified by ' $pwd ';


Flush privileges;


Eof



Done



Create User.txt

YOON_RW Wy811jnjtzcjjfzo. Ui_8q8i8k09kx Yoon
YOON_RW Wy811jnjtzcjjfzo. Ui_8q8i8k10kx Yoon
YOON_RW Wy811jnjtzcjjfzo. Ui_8q8i8k11kx Yoon
YOON_RW Wy811jnjtzcjjfzo. Ui_8q8i8k12kx Yoon
YOON_RW Wy811jnjtzcjjfzo. Ui_8q8i8k13kx Yoon
2018 Yoon_rw Wy811jnjtzcjjfzo. Ui_8q8i8k14kx Yoon
2020 YOON_RW Wy811jnjtzcjjfzo. Ui_8q8i8k15kx Yoon


[Email protected] ~]# sh add_user.sh

Multi-instance MySQL bulk add users and passwords and authorize