This is an issue with the bundled JDBC driver (MySQL 8 changed enough things that it broke backwards compatibility). A new version of the driver will be in new installs in 7.9.9, but in the short term you can install ConnectorJ from MySQL directly: https://dev.mysql.com/downloads/connector/j/ and install it on your system (refer to this page for more info).
At a minimum, you’ll need to change the default ‘Extra Connection Properties’ to have zeroDateTimeBehavior=CONVERT_TO_NULL; and probably also add useSSL=false;allowPublicKeyRetrieval=true;