You are here:  » MySQL 8.0 support


MySQL 8.0 support

Submitted by Alex on Sat, 2019-01-26 14:20 in

Hi David,

Do you have any advice / experience with PT running on MySQL 8.0?

Submitted by support on Mon, 2019-01-28 09:18

Hi Alex,

None of the deprecated functions are used by the script so there shouldn't be any problems but I will set-up a test server and give it a go both as a new install and upgrading MySQL against an existing database - i'll report back if anything to be aware of...

Cheers,
David.
--
PriceTapestry.com

Submitted by MikeyC on Tue, 2019-04-09 08:07

Hi David,

any news on your test with MYSQL 8 ? Just got me a new VPS, and i am thinking about upgrading to MYSQL 5.7 or 8, but not sure of 8 yet.

Submitted by support on Tue, 2019-04-16 09:34

Hi Mikey,

It does appear that there are complications regarding the new authentication methods and password hash functions used in MySQL 8 and calling from php-mysql (PDO) library so I am going to need to do some further research and tests regarding this.

It should be possible with the appropriate configuration of mysql-server and ensuring that users are configured with legacy passwords but at this time I would not recommend upgrading to version 8. No problems at all with 5.7 of course.

Cheers,
David.
--
PriceTapestry.com

Submitted by MikeyC on Thu, 2019-04-18 17:44

Hi David,

Just installed 8.0 last weekend along with php 7.2, ran into the complication with the authentication method and password hash functions. Luckily there is a workaround for that using legacy mode. Up untill now no probs other than that. No problem with imports, registering feeds or searches up untill now.