MySQL version 8 has added new reserved words. These words can't be used in an SQL query unless you back tick the table name - https://dev.mysql.com/doc/refman/8.0/en/keywords.html.
CFWebstore uses the table name 'Groups' which is now reserved. To fix the problem you need to update any queries that use table.groups. Here's an example in users/login/act_login_permissions.cfm:
Notice we're using back ticks (`) not single quotes ('). They mean different things in MySQL.
Do a sitewide search for '#Request.DB_Prefix#Groups' and update each instance.