Script création de comptes, droits ….

Fichier createdb.skel
----------------------------
CREATE USER 'XXX'@'%' IDENTIFIED BY 'XXX';

GRANT USAGE ON * . * TO 'XXX'@'%' IDENTIFIED BY 'XXX' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS `XXX` ;
GRANT ALL PRIVILEGES ON `XXX` . * TO 'XXX'@'%';



Fichier createdbscript.sh
---------------------------------
Appel : ./createdbscript.sh A B C D E F G H I J >>createdb.sql
------------------
for i in $*
do 
  for j in 00 01 02 03 04 05 06 07 08 09 10 11 12; 
  do
 
      sed s/XXX/$i$j/g createdb.skel ;
 
  done; 

done

 

Posté le 6 septembre 2011