MySQL To use this as a variable, set Allow User Variables=true connection string

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"