Hello all,

I’ve come across a really old database hosted on a 15 year old Ubuntu machine. Sadly we don’t have the passwords etc anymore for said machine, however it holds a really important data base.

I’ve done a migration using MySQL workbench into a new MySQL 8 Database as a test. However the applications front end looks to be calling “SELECT * FROM SYSTEM” and triggering a 1604 incorrect syntax error when. I’m trying to test on that database.

The old database was version 5.5 of MySQL so I suspect that SYSTEM Is now a reserved word.

Sadly I cannot change the front end.

So my question is, is there something obvious I’m missing to allow select * from system to just work or am I better off trying to regress back to version 5 of MySQL?