Is MySQL 8.0 supported?

[AIC-BV]

Winter CMS Build

dev-develop

PHP Version

8.1

Database engine

MySQL/MariaDB

Plugins installed

No response

Issue description

I am trying to set up a new website.
I copied an old project and started cleaning it up because the composer create command is currently not working.

In my .env file I set up my DB variables.
This is a 8.0 DB and it doesn't seem to work. I cannot connect to this.
My copied project had a 5.7 DB. I tried that one and it instantly works.

Is it possible that SQL 8.0 database is not yet supported?

Steps to replicate

Try to connect to a SQL 8.0 database

Workaround

Use an older SQL database, but downgrading is not supported.

[bennothommo]

I'm using a MySQL 8 database for a live website currently, and there hasn't been any other people reporting any issues with MySQL 8 as far as I know, so I don't think it is that.

It could be a configuration issue - for example, MySQL 8 has some different SQL_MODE setting defaults compared to other versions. Perhaps it could be related to that?

[AIC-BV]

My hosting provider said I have to connect using SSH on MySQL 8.0
Anyways, that doesn't seem to work on my MySQL Workbench so I contacted them and am waiting for a reply