...
(nb : les commandes ci-dessous suppose que le mot de passe root mysql est stocké dans /root/.my.cnffile-with-root-password)
| Bloc de code |
|---|
root_password=`sudo sed -n 's/password="\(.*\)"/\1/p' /root/file-with-root-password`
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"
|
...