Actually the real issue is because MySQL 8 added a new reserved word called `GROUPS` which conflicts with the name of the table and the alter statements aren't properly qualified.
Simply add the backticks (`) around `groups` and the ALTER will succeed.
Trouble with db update 21_04_001 on MySQL 8
-
-
-
-
-
in Archived Reports (Two)(Resolved issues)
Posted
Actually the real issue is because MySQL 8 added a new reserved word called `GROUPS` which conflicts with the name of the table and the alter statements aren't properly qualified.
Simply add the backticks (`) around `groups` and the ALTER will succeed.
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
(R); added in 8.0.2 (reserved)