Can MySQL 8 be configured with the new sha2 for OJS v3?

Even if you have the old encryption setting in config.inc.php, it is only being used for legacy passwords where the user is not active.