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?
mySQL update to version 8
-
- 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
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.
-
- Lead Developer
- Posts: 2439
- Joined: Tue Oct 29, 2019 9:37 am
- : Buy Me A Beverage
- Has thanked: 51 times
- Been thanked: 138 times
Re: mySQL update to version 8
My current set up:
MySQL 8.0.31
PHP 8.2
Phoenix 1.0.8.21
Works more or less fine.
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.
-
- 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
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.
-
- Lead Developer
- Posts: 2439
- Joined: Tue Oct 29, 2019 9:37 am
- : Buy Me A Beverage
- Has thanked: 51 times
- Been thanked: 138 times
Re: mySQL update to version 8
Installation works very well for me.
What does the error_log say?
Or what is happening on the installation exactly?
What does the error_log say?
Or what is happening on the installation exactly?
I don't know what this means.accept the the authentification
Gamechanger Addon: Queued Emails, try before you buy.
-
- 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
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.
-
- Lead Developer
- Posts: 2439
- Joined: Tue Oct 29, 2019 9:37 am
- : Buy Me A Beverage
- Has thanked: 51 times
- Been thanked: 138 times
Re: mySQL update to version 8
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.
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.
-
- VIP Member
- Posts: 112
- Joined: Thu Mar 04, 2021 1:18 pm
- Has thanked: 2 times
- Been thanked: 6 times
Re: mySQL update to version 8
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.20 - php 7.3.24
Now working on 1.0.8.20 - php 7.3.24