mySQL update to version 8

Ask the community for help and support.
Post Reply
Philo2005
Posts: 11
Joined: Fri Mar 26, 2021 7:20 am
Has thanked: 6 times
Been thanked: 1 time

mySQL update to version 8

Post 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?

Tags:
artfulweb
VIP Member
VIP Member
Posts: 119
Joined: Thu Oct 29, 2020 12:34 pm
Has thanked: 11 times
Been thanked: 4 times

Re: mySQL update to version 8

Post 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.
burt
Lead Developer
Lead Developer
Posts: 2423
Joined: Tue Oct 29, 2019 9:37 am
Has thanked: 49 times
Been thanked: 137 times

Re: mySQL update to version 8

Post by burt »

My current set up:

MySQL 8.0.31
PHP 8.2
Phoenix 1.0.8.21

Works more or less fine.
Gamechanger Addon: Queued Emails, try before you buy.
artfulweb
VIP Member
VIP Member
Posts: 119
Joined: Thu Oct 29, 2020 12:34 pm
Has thanked: 11 times
Been thanked: 4 times

Re: mySQL update to version 8

Post 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.
burt
Lead Developer
Lead Developer
Posts: 2423
Joined: Tue Oct 29, 2019 9:37 am
Has thanked: 49 times
Been thanked: 137 times

Re: mySQL update to version 8

Post 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.
Gamechanger Addon: Queued Emails, try before you buy.
artfulweb
VIP Member
VIP Member
Posts: 119
Joined: Thu Oct 29, 2020 12:34 pm
Has thanked: 11 times
Been thanked: 4 times

Re: mySQL update to version 8

Post 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.
artfulweb
VIP Member
VIP Member
Posts: 119
Joined: Thu Oct 29, 2020 12:34 pm
Has thanked: 11 times
Been thanked: 4 times

Re: mySQL update to version 8

Post 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?
burt
Lead Developer
Lead Developer
Posts: 2423
Joined: Tue Oct 29, 2019 9:37 am
Has thanked: 49 times
Been thanked: 137 times

Re: mySQL update to version 8

Post 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.
Gamechanger Addon: Queued Emails, try before you buy.
Xpajun
VIP Member
VIP Member
Posts: 104
Joined: Thu Mar 04, 2021 1:18 pm
Has thanked: 2 times
Been thanked: 6 times

Re: mySQL update to version 8

Post 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
Current Store is now running 1.0.7.5 - php 7.3.24
Now working on 1.0.8.19 - php 7.3.24
Post Reply