#!/bin/bash for i in $(mysql -e 'SHOW DATABASES;' | grep -v "^Database"); do PASSWORD=$(cat /root/user_details.txt /root/user_details_orig.txt | grep -A2 $i | grep "Database Password:" | tail -1 | cut -f2 -d":" | sed 's/ //g') mysql --database="mysql" --execute="GRANT ALL PRIVILEGES ON $i.* TO '$i'@'localhost' IDENTIFIED BY '$PASSWORD';" done