Trying to disable ONLY_FULL_GROUP_BY. Getting an error

[jamessmitth]

I installed an applicaition where it says I have to disable ONLY_FULL_GROUP_BY. I went into phpmyadmin and I tried editing the sql mode.

I get a

How do I fix this.

[eris]

Login with root and “password” that is saved in /usr/local/hestia/conf/mysql.localhost.conf

[jamessmitth]

What do you mean by login with root like ssh? or in the hestia panel

[eris]

No root in phpmyadmin

[jamessmitth]

How do I figure out the password.

[eris]

@eris

/usr/local/hestia/conf/mysql.localhost.conf

Check …