UNIX and Linux Applications

while read user; do
   
  userid=$user
  passwd="changeme"
  query="grant usage on mysql.USERS.* to $userid identified by '$passwd'";

  mysql -u<root> -p<password>
  $query;
  flush privileges;
  quit;

done < userid_file

while read user; do
   
  userid=$user
  passwd="changeme"
  print "grant usage on <database>.* to '"$user"' identified by '"$passwd"';"  >> grant_file

done < userid_file


mysql -BCNnqs --disable-pager -u<root> -p<password> <<EOJ
source /PATH/to/grant_file
flush privileges;
quit;

EOJ

while read user; do
   
  userid=$user
  passwd="changeme"

  mysql -u<root> -p<password>
  grant usage on *.* to '$userid' identified by '$passwd';
  flush privileges;
  quit

done < userid_file