Azure MySQL server allow disable 'sql_mode=only_full_group_by'

Question

I have an application that runs on node.js and queries the database hosted on Azure MySQL server, I have encountered an error message during a query with group by

"...this is incompatible with sql_mode=only_full_group_by".

Subsequently, I have tried to change my SQL user privilege with

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

but got an error message:

Error Code: 1227. Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

Answer 1

You can do this from the "server parameters" in azure portal. You can get the option of sql_mode there. Just change that and save it

https://learn.microsoft.com/en-us/azure/mysql/howto-server-parameters