- Fix ANSI labels to put EOF1 and EOF2 after each file mark.

[bacula/bacula] / bacula / src / cats / grant_mysql_privileges.in

diff --git a/bacula/src/cats/grant_mysql_privileges.in b/bacula/src/cats/grant_mysql_privileges.in
index d66c884a339eb3db1730ad3286d85830c98a6603..aeafd65f1c32b6bcb44cc710708b1bf8ec339753 100644 (file)
--- a/bacula/src/cats/grant_mysql_privileges.in
+++ b/bacula/src/cats/grant_mysql_privileges.in
@@ -1,23 +1,19 @@
 #!/bin/sh
 #
-# shell script to create Bacula database(s)
+# shell script to grant privileges to the bacula database
 #
-
+USER=bacula
 bindir=@SQL_BINDIR@
 
-if $bindir/mysql -u root -f <<END-OF-DATA
+if $bindir/mysql $* -u root -f <<END-OF-DATA
 use mysql
-grant all privileges on *.* to kern@localhost with grant option;
-grant all privileges on *.* to kern@"%" with grant option;
-grant all privileges on *.* to kelvin@localhost with grant option;
-grant all privileges on *.* to kelvin@"%" with grant option;
-grant all privileges on *.* to bacula@localhost with grant option;
-grant all privileges on *.* to bacula@"%" with grant option;
+grant all privileges on bacula.* to ${USER}@localhost;
+grant all privileges on bacula.* to ${USER}@"%";
 select * from user;
 flush privileges;
 END-OF-DATA
 then
-   echo "Privileges for kern, kelvin, and bacula granted."
+   echo "Privileges for ${USER} granted."
    exit 0
 else
    echo "Error creating privileges."