Questions Installing 2022R1 locally gives an error illegal mix of collations

While trying to install 2022R1 locally for testing, I get the following error:

illegal mix of collations (utf8mb4_unicode_ci.IMPLICIT) and (utf8mb4_0900_ai_ci.IMPLICIT) for operation '='

I tried looking it up in reference to Acumatica, but couldn't find anything. I did find it in reference to mySQL (which is what I'm installing it on), but it talks about tables having different unicodes. The fixes suggests changing table and table column collations and gives steps, but that is if you were building the database. In my case the Acumatica install is building the database.

Has anyone else been successful in installing 2022R1 on mysql? Do you get this error?

I am running 2021R1 on another instance and didn't run into any errors or issues installing on the same server.