From a2fe71a6d3b999b30103876d9756d5415c428d7f Mon Sep 17 00:00:00 2001 From: Chris Smith Date: Thu, 8 Apr 2010 17:01:10 +0100 Subject: [feature/webpi] Hopefully finally fix this --- build/webpi/install/mysql.sql | 16 +++++++++++++++- 1 file changed, 15 insertions(+), 1 deletion(-) (limited to 'build/webpi') diff --git a/build/webpi/install/mysql.sql b/build/webpi/install/mysql.sql index 8efdd053ff..8c1ae2e550 100644 --- a/build/webpi/install/mysql.sql +++ b/build/webpi/install/mysql.sql @@ -1 +1,15 @@ -USE PlaceHolderForDb$$ DROP PROCEDURE IF EXISTS add_user $$ CREATE PROCEDURE add_user() BEGIN DECLARE EXIT HANDLER FOR 1044 BEGIN END; GRANT ALL PRIVILEGES ON PlaceHolderForDb.* to 'PlaceHolderForUser'@'PlaceHolderForServer' IDENTIFIED BY 'PlaceHolderForPassword'; FLUSH PRIVILEGES; END $$ CALL add_user() $$ DROP PROCEDURE IF EXISTS add_user $$ \ No newline at end of file +USE PlaceHolderForDb$$ + +DROP PROCEDURE IF EXISTS add_user $$ + +CREATE PROCEDURE add_user() +BEGIN +DECLARE EXIT HANDLER FOR 1044 BEGIN END; +GRANT ALL PRIVILEGES ON PlaceHolderForDb.* to 'PlaceHolderForUser'@'PlaceHolderForServer' IDENTIFIED BY 'PlaceHolderForPassword'; +FLUSH PRIVILEGES; +END +$$ + +CALL add_user() $$ + +DROP PROCEDURE IF EXISTS add_user $$ -- cgit v1.2.1