Add support for MySQL 8.0.11 and newer #175
Description
Currently MySQL 8.0.20 and newer are supported. The reason MySQL 8.0.11 - 8.0.19 inclusive do not work with mysql-memory-server is because in the Executor.ts file there is a check to see if the error log includes the string "InnoDB initialization has ended" which would indicate that the database has successfully been initialised. InnoDB does not log that message with versions 8.0.11 - 8.0.19. It has only started logging that in version 8.0.20.
Since this package uses --initialize-insecure to initialise the database, there is a warning in the error log saying to consider not using --initialize-insecure to set a password for the database. This warning shows up in MySQL 8.0.11 - 8.0.19 and the versions that are currently supported by mysql-memory-server. We can look out for the --initialize-insecure warning instead of the InnoDB initialization ended message to tell if the database has successfully initialised or not.
Making this change is a step towards adding support for previous versions of MySQL as well (<8.0.11), but making this change will only add support for MySQL 8.0.11 - 8.0.19 inclusive for this package. More work is needed to be done to this package to allow support for <8.0.11.