From b87397a3542533e4c9af9c54ee8f3ef24d601cd0 Mon Sep 17 00:00:00 2001
From: Kern Sibbald <kern@sibbald.com>
Date: Wed, 13 Jul 2016 10:41:45 +0200
Subject: [PATCH] Explicitly create MySQL user in grant_mysql_privileges.in

---
 bacula/src/cats/grant_mysql_privileges.in | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/bacula/src/cats/grant_mysql_privileges.in b/bacula/src/cats/grant_mysql_privileges.in
index ab85680ade..f19eac11a2 100644
--- a/bacula/src/cats/grant_mysql_privileges.in
+++ b/bacula/src/cats/grant_mysql_privileges.in
@@ -2,7 +2,7 @@
 #
 # shell script to grant privileges to the bacula database
 #
-# Copyright (C) 2000-2015 Kern Sibbald
+# Copyright (C) 2000-2016 Kern Sibbald
 # License: BSD 2-Clause; see file LICENSE-FOSS
 #
 db_user=${db_user:-@db_user@}
@@ -17,6 +17,14 @@ if [ "$db_ssl_options" != "" ]; then
    ssl_options="require $db_ssl_options"
 fi
  
+if $bindir/mysql $* -u root -f 2>/dev/null 1>/dev/null	<<EOD
+use mysql;
+create user ${db_user} ${pass};
+EOD
+then
+  echo "Created MySQL database user: ${db_user}"
+fi
+
 if $bindir/mysql $* -u root -f <<END-OF-DATA
 use mysql
 grant all privileges on ${db_name}.* to ${db_user}@localhost ${pass} ${ssl_options};
-- 
2.39.2