#!/bin/sh
#
# shell script to grant privileges to the bareos database
#
db_user=${db_user:-bareos}
bindir=/bin
db_name=${db_name:-bareos}
db_password=${db_password:-}
if [ "$db_password" != "" ]; then
   pass="identified by '$db_password'"
fi

if $bindir/mysql $* -u root -f <<END-OF-DATA
use mysql
grant all privileges on ${db_name}.* to ${db_user}@'localhost' ${pass};
grant all privileges on ${db_name}.* to ${db_user}@'127.0.0.1' ${pass};
grant all privileges on ${db_name}.* to ${db_user}@'::1' ${pass};
select user,password,host from mysql.user where user="${db_user}";
flush privileges;
END-OF-DATA
then
   echo "Privileges for user ${db_user} granted on database ${db_name}."
   exit 0
else
   echo "Error creating privileges."
   exit 1
fi
