want to disable "only_full_group_by"?

[baghray11]

Hello

I want to disable set global sql_mode = (select replace(@@sql_mode,'ONLY_FULL_GROUP_BY', '')); but when i paste it into SQL then i receive this error :

Error
SQL query:

set global sql_mode = (select replace(@@sql_mode,'ONLY_FULL_GROUP_BY', ''))

MySQL said:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Please help, how to grant privileges?

 

[cPanelLauren]

What user are you logged in as? If you're trying to change the global SQL mode You won't be able to do this unless you're the root user.