RT 5.0.1 initialize-database fails on Ubuntu 20 LTS


It looks like RT 5.0.1 can’t be installed to Ubuntu 20 LTS due to the fact that the mysql server version is 8 and Groups is a reserved word in its SQL syntax. Has anyone managed to work around this without downgrading mysql? Are there any plans to sort out the issue by the developers of RT?

Excerpt of the error message:

DBD::mysql::st execute failed: 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 (
Name varchar(200) NULL ,
De’ at line 1 at /some/path/src/rt-5.0.1/sbin/…/lib/RT/Handle.pm line 551.
make[1]: *** [Makefile:390: initialize-database] Error 9

Seems there’s previous experience in the forum:

didn’t work for me, and,

that describes the problem and confirms this is still an unsolved issue.

The easiest way out seems to say farewell to mysql and welcome to mariadb …