From: Chris Koeritz <fred@gruntose.com>
Date: Mon, 18 Dec 2017 20:54:59 +0000 (-0500)
Subject: skip user creation if already exists, avoid errors
X-Git-Tag: 2.140.106^2~3^2~4
X-Git-Url: https://feistymeow.org/gitweb/?p=feisty_meow.git;a=commitdiff_plain;h=19100b69028fcf9c22228dcc36abee4f62ab40f8

skip user creation if already exists, avoid errors
---

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"