Getting SQL Error While executing MySQL Queries -

[NilukaSripalim]

Describe the issue:**

dbscripts/identity/stored-procedures/mysql/confirmation-code-cleanup

encountering a SQL error while executing MySQL queries in the dbscripts/identity/stored-procedures/mysql/confirmation-code-cleanup

PROCEDURE .WSO2_CONFIRMATION_CODE_CLEANUP_RESTORE does not exist PROCEDURE .WSO2_CONFIRMATION_CODE_CLEANUP does not exist

Error occurred during SQL script execution

Reason:
SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$
CREATE PROCEDURE `WSO2_CONFIRMATION_CODE_CLEANUP_RESTORE`()
BEGIN
 ' at line 1 

Error occurred during SQL script execution

Reason:
SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$
CREATE PROCEDURE `WSO2_CONFIRMATION_CODE_CLEANUP_RESTORE`()
BEGIN
 ' at line 1

2. ` dbscripts/identity/stored-procedures/mysql/par-request-cleanup/mysql-par-request-cleanup.sql

   
   Error occurred during SQL script execution

Reason: SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$ CREATE PROCEDURE WSO2_PAR_REQUEST_CLEANUP() BEGIN

-- -------' at line 1

[ashanthamara]

Scripts can be successfully executed against the MYSQL identity DB.

Above issue could occur when setting the DELIMETER from the script executing software.