From 19100b69028fcf9c22228dcc36abee4f62ab40f8 Mon Sep 17 00:00:00 2001
From: Chris Koeritz <fred@gruntose.com>
Date: Mon, 18 Dec 2017 15:54:59 -0500
Subject: [PATCH] skip user creation if already exists, avoid errors

---
 scripts/site_avenger/revamp_cakelampvm.sh | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/scripts/site_avenger/revamp_cakelampvm.sh b/scripts/site_avenger/revamp_cakelampvm.sh
index 668a3a09..ece38d9b 100644
--- a/scripts/site_avenger/revamp_cakelampvm.sh
+++ b/scripts/site_avenger/revamp_cakelampvm.sh
@@ -229,13 +229,13 @@ echo successfully patched the samba configuration to enable writes on user home
 sep
 
 mysql -u root -p"$mysql_passwd" <<EOF
-  create user 'root'@'%' IDENTIFIED BY '$mysql_passwd';
+  create user if not exists 'root'@'%' IDENTIFIED BY '$mysql_passwd';
   grant all privileges on *.* TO 'root'@'%' with grant option;
 
-  create user 'wampcake'@'%' IDENTIFIED BY 'bakecamp';
+  create user if not exists 'wampcake'@'%' IDENTIFIED BY 'bakecamp';
   grant all privileges on *.* TO 'wampcake'@'%' with grant option;
 
-  create user 'lampcake'@'%' IDENTIFIED BY 'bakecamp';
+  create user if not exists 'lampcake'@'%' IDENTIFIED BY 'bakecamp';
   grant all privileges on *.* TO 'lampcake'@'%' with grant option;
 EOF
 test_or_die "configuring root, wampcake and lampcake users on mysql"
-- 
2.34.1