mysql信息获取

dbip='10.0.0.175'
for j in $dbip
do
user=`mysql -h$j  -uroot -p'My$Sprd&00' -e """SELECT DISTINCT CONCAT('''',user,'''@''',host,'''') AS query   FROM mysql.user;""" | grep -v query`
#echo "">./test
for i in $user
do
#echo $i
grantall=`mysql  -h$j -uroot -p'My$Sprd&00' -e """SHOW GRANTS for  $i;"""  |grep -v PASSWORD|grep TO `
echo $grantall
#grant=`echo $grantall |awk -F[ON] '{print $2}'|awk -F[.] '{print $1}'`
#for getgrant in $grantall
#do
#echo $getgrant
db=`echo ${grantall#* ON}|cut -d "." -f1`
privi1=`echo  ${grantall#*GRANT }`
privi=`echo  ${privi1%% ON*}`
echo $j","$i","$db","$privi >>./test
done
done
#done

 

 

 mysql -u root -p'My$Sprd&00' -e " select  CONCAT(Time,',',pending_Num)   from jenkins_log.shqueue_pending  where Time >='2019-10-01 00:00:00' and Time <='2019-12-31 00:00:00' " >/tmp/test.csv