授权脚本思路

cat neiwang_db.txt | while read line
do

        n1=` echo ${line}|grep -v ^#|awk '{print $1}' `
        n2=`echo ${line}|grep -v ^#|awk '{print $2}' `
        #echo $n1 
        #echo $n2
        #echo database is :
        echo "`mysql -h$n1 -e "show databases;"`"|grep -v Database|grep -v information_schema|grep -v mysql|grep -v performance_schema|grep -v sys>$Grant_Db_File
        db=$(cat  ${Grant_Db_File})
        mysql -u -p -h$n1 -e "grant select on $db.* to user_1@'100.%' identified by 'user1pass';"
        sleep 10
done