...
(nb : les commandes ci-dessous suppose que le mot de passe root mysql est stocké dans /root/file-with-root-password.my.cnf)
| Bloc de code |
|---|
root_password=`sudo sed -n 's/password="\(.*\)"/\1/p' /root/file-with-root-password`.my.cnf` dbvar() { sed -n 's![[:space:]]*!!g; s/esup.db.'$1'=//p' /usr/local/esup/esup-package/config.properties; } username=`dbvar username` password=`dbvar password` database=`dbvar url | sed 's!jdbc:mysql://localhost/!!'` echo "grant all on $database.* to $username identified by '$password';" | mysql -uroot -p"$root_password" mysqladmin -u"$username" -p"$password" create "$database" |
...