Create user seems to fail every time
So added drop user statement to overcome
Change-Id: Ie50085771d38759c5b7792515ac2f199a5d6530e
Issue-ID: SO-1674
Signed-off-by: Ramesh Parthasarathy(rp6768)<ramesh.parthasarathy@att.com>
DROP DATABASE IF EXISTS `camundabpmn`;
CREATE DATABASE `camundabpmn`;
DELETE FROM mysql.user WHERE User='camundauser';
+DROP USER 'camundauser';
CREATE USER 'camundauser';
GRANT ALL on camundabpmn.* to 'camundauser' identified by 'camunda123' with GRANT OPTION;
FLUSH PRIVILEGES;
DROP DATABASE IF EXISTS `requestdb`;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `requestdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
DELETE FROM mysql.user WHERE User='requestuser';
+DROP USER 'requestuser';
CREATE USER 'requestuser';
GRANT ALL on requestdb.* to 'requestuser' identified by 'request123' with GRANT OPTION;
FLUSH PRIVILEGES;
DROP DATABASE IF EXISTS `catalogdb`;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `catalogdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
DELETE FROM mysql.user WHERE User='cataloguser';
+DROP USER 'cataloguser';
CREATE USER 'cataloguser';
GRANT ALL on catalogdb.* to 'cataloguser' identified by 'catalog123' with GRANT OPTION;
FLUSH PRIVILEGES;