MySQL 5.7 and detectServerType

[MJFShark]

Hi All!

In TZMySQLDatabaseMetadata.detectServerType it is looking for either 'mysql' or 'mariadb' in the results of
show variables like 'version' and show variables like 'version_comment'.

However, my main test MySQL 5.7 database doesn't actually have the mysql text in the version_comment. It shows:

version: 5.7.32-0ubuntu0.18.04.1
version_comment: (Ubuntu)

I have no idea if it's something that went wrong during install or if it's just common for it not to have it. My MySQL 8 install does show 'mysql' in the comment btw.

And so I was wondering if TZMySQLDatabaseMetadata.detectServerType should default to MySQL even if it doesn't find the 'mysql' text, butI don't know anything about the various versions/forks of MySQL that need to be detected. Any thoughts on this appreciated!

-Mark