MySQL v8 Errors

[craigerskine]

Affected Symphony version(s) : 7.10
PHP version(s) : 7
MySQL version(s): 8

I'm getting this error after my host upgraded MySQL to v8. I cannot downgrade to v5. Is there a quick fix in Symphony or a MySQL command I can run to fix this?

[alexbirukov]

Hi. You need grant permissions by user in MySQL console:
GRANT SESSION_VARIABLES_ADMIN ON . TO 'user'@'localhost';