Named Query - MySQL SET Variable Not Working

[mcgheeiv]

Using a MySQL variable in a data query throwing me an error

If you add allowMultiQueries = true to the Extra Configuration Properties in the advanced database connection properties, you should be able to use MySQL variables in the query. The query, however, can only return one dataset. https://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html