Issue: Getting the following error while executing the query against MySQL DB:
To use this as a variable, set 'Allow User Variables=true' in the connection string.
Solution is to add the follwing line at the last of your MySQL connection string:
;Allow User Variables=True
The full connection string will look like this:
"YourConnection": "server=localhost;user=root;password=Password;database=DBName;Allow User Variables=True"