Nextclound 16 and MySQL 8.0.16


i try to install Nextcloud and MySQL with docker. Both are the latest versions.

I got an error during the installation when nextcloud try to create the database tables.

Error while trying to create admin user: An exception occurred while executing ‘CREATE TABLE groups (gid VARCHAR(64) DEFAULT ‘’ NOT NULL, PRIMARY KEY(gid)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ENGINE = InnoDB ROW_FORMAT = compressed’: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘groups (gid VARCHAR(64) DEFAULT ‘’ NOT NULL, PRIMARY KEY(gid)) DEFAULT CHARACTER’ at line 1

I think the reason behind is that with MySQL 8.0.2 GROUPS is now a reserverd word and cannot used as table name without quoting.

Regards, Henry

As workaround until some fix is available set NEXTCLOUD_TABLE_PREFIX to oc_ or something non empty.