Maian Support not working with MySQL 8.0

Dreamhost just migrated my VPS/SQL to the new MySQL 8.0 servers and I am now getting errors and can not access my support site. The error I get is...

MySQLi Error on 20 January 2022 @ 10:53AM
Code: 1231
Error: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
File: 37
Line: /home/jsinley/sinleymarketing.com/helpdesk/control/lib/db.php
DB Query:

SET `sql_mode` = 'IGNORE_SPACE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

Need help getting Maian Support updated to support MySQL 8.0 as the upgrade / migration was not voluntary with DreamHost.