#! /bin/sh
# ajout d'un user mysql et d'une table eponyme.
#
mysql -uroot -p$1 -e "CREATE DATABASE $2;"
echo database $2 ok ...
mysql -uroot -p$1 -e "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON $2.* TO '$2'@'pouetpouet.dyndns.org' IDENTIFIED BY '$3';"
mysql -uroot -p$1 -e "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON $2.* TO '$2'@'localhost' IDENTIFIED BY '$3';"
mysql -uroot -p$1 -e "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON $2.* TO '$2'@'%' IDENTIFIED BY '$3';"
mysqladmin -uroot -p$1 reload
echo done
# fin du script |
