git.sur5r.net Git - bacula/bacula/blob - bacula/src/cats/grant_mysql_privileges.in

   1 #!/bin/sh
   2 #
   3 # shell script to grant privileges to the bacula database
   4 #
   5 db_user=${db_user:-@db_user@}
   6 bindir=@MYSQL_BINDIR@
   7 db_name=${db_name:-@db_name@}
   8 db_password=@db_password@
   9 if [ "$db_password" != "" ]; then
  10    pass="identified by '$db_password'"
  11 fi
  12
  13 if $bindir/mysql $* -u root -f <<END-OF-DATA
  14 use mysql
  15 grant all privileges on ${db_name}.* to ${db_user}@localhost ${pass};
  16 grant all privileges on ${db_name}.* to ${db_user}@"%" ${pass};
  17 select * from user;
  18 flush privileges;
  19 END-OF-DATA
  20 then
  21    echo "Privileges for user ${db_user} granted on database ${db_name}."
  22    exit 0
  23 else
  24    echo "Error creating privileges."
  25    exit 1
  26 fi