Page 1 of 1

mySQL update to version 8

Posted: Fri Jan 21, 2022 8:04 am
by 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?

Re: mySQL update to version 8

Posted: Wed Jan 24, 2024 11:15 pm
by 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.

Re: mySQL update to version 8

Posted: Thu Jan 25, 2024 9:25 am
by burt
My current set up:

MySQL 8.0.31
PHP 8.2
Phoenix 1.0.8.21

Works more or less fine.

Re: mySQL update to version 8

Posted: Thu Jan 25, 2024 10:46 am
by 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.

Re: mySQL update to version 8

Posted: Thu Jan 25, 2024 11:23 am
by 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.

Re: mySQL update to version 8

Posted: Thu Jan 25, 2024 3:03 pm
by 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.

Re: mySQL update to version 8

Posted: Fri Jan 26, 2024 10:53 am
by 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?

Re: mySQL update to version 8

Posted: Fri Jan 26, 2024 10:59 am
by 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.

Re: mySQL update to version 8

Posted: Mon Feb 12, 2024 11:03 am
by 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