mySQL update to version 8

[Philo2005]

My host provider announced to update mysql from version 5.7 to 8 in the next time.
Currently I am running Phoenix 1 0 7 15.

Is this Phoenix version already compatible with mysql version 8
and if not which is the minimum version of Phoenix supporting mysql 8?

[artfulweb]

Same problem except that my hoster gives no more choice in creating databases, they have to be mysql 8.0 or Maria 10! I am now desperate as I can no longer test installations... Installation fails.

[burt]

My current set up:

MySQL 8.0.31
PHP 8.2
Phoenix 1.0.8.21

Works more or less fine.

[artfulweb]

Hi, Burt, the problem is installing, it does not accept the the authentification as used before and I can not find a work around. And for working sites we will be in trouble when they force us to change which is happening shortly.

[burt]

Installation works very well for me.
What does the error_log say?
Or what is happening on the installation exactly?

accept the the authentification

I don't know what this means.

[artfulweb]

Sorry, Burt, it was an error on my part as I use another language and neglected to add in the install files in includes/translations the language file so it was unable to connect as the 2nd language is the default language.

[artfulweb]

One question, Burt... for live sites on mysql 5.7 databases how do we switch to 8.0? Do we have to reinstall the website with a new database?

[burt]

Your host would be doing this update from mysql 5.7 to 8.
They need to make sure the disk image is correct.

There should be nothing for you to do.
However, it is very good to keep a backup of your site and database in case your host breaks it.

[Xpajun]

My question is will 1.0.7.5 (current store) work with 8 or shoould I wait until I get 1.0.8.20 on-line