MySQL install will fail if SQL strict mode or NO_ZERO_DATE is enabled.
The extension makes use of its own cache table, which it creates with a TIMESTAMP field that may have a meaningless value (e.g. 0 or NULL); however certain DB engines don't allow this and insist that all timestamp fields have values.
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmode_no_zero_date