Upgrades to MySQL 8.0
BMPCreated with Sketch.BMPZIPCreated with Sketch.ZIPXLSCreated with Sketch.XLSTXTCreated with Sketch.TXTPPTCreated with Sketch.PPTPNGCreated with Sketch.PNGPDFCreated with Sketch.PDFJPGCreated with Sketch.JPGGIFCreated with Sketch.GIFDOCCreated with Sketch.DOC Error Created with Sketch.
Question

Upgrades to MySQL 8.0
by
MikaelD1
Newbie
Created on 2024-05-21 20:29:54 (edited on 2024-11-18 11:06:45) in Hébergements Web

Post en français ici.

Brace yourself, MySQL 8.0 is coming soon on the databases delivered with your web hostings, also called "SharedSQL". For the vast majority of cases, the migration will be seamless and you don't need to do anything. But certain, rarer cases require action on your part. We have listed here the most common cases.

If we find other significant cases, we'll add them here.

* New reserved words
TL;DR: MySQL 8.0 introduced new reserved words, that can lead to rare errors on client side.
Details here.

* Prepare your old Drupal
TL;DR: Older versions of Drupal does not work with MySQL 8.0. Update now.
Details here.

* Prepare your (really) old Wordpress
TL;DR: To avoid accent issues after the MySQL 5.7 to 8.0 upgrade, check that DB_CHARSET is set in your Wordpress' wp-config.php.
Details here.
Upvotes (0)
6301 Views
5 Replies ( Latest reply on 2024-11-18 11:07:17 by
FabienB42
)

I use php 5.6 for my project. Will the procedural style

mysql_connect('xxx.mysql.db', 'xxx', pwd)

still work? I've read that the password hashing changed with mysql 8
Helpful (0)

Yes, this still works with the 8.0 version that will be deployed.

I wrote more details about the hash change https://community.ovhcloud.com/community/fr/logs-base-de-donnees-plugin-mysql-native-password-reported-mysql-native?id=community_question&sys_id=7fe4fa8474eb4ad01e118a96965def94?u=mikaeld1">here. Feel free to tell me if you need an English version.
Helpful (0)
B

Our database is mariadb 10.0.38, not mysql 5.7.
Is this being migrated? Your email didn't mention it.
Helpful (0)

No, only the databases coming with a https://www.ovhcloud.com/en-gb/web-hosting/">web hosting plan are concerned.

MariaDB 10.0 is quite old. No managed databases services handled by OVHcloud still propose such a version. So, looks like your database is not a managed one. You should definitely upgrade it or move to a managed databases service like https://www.ovhcloud.com/en-gb/web-cloud/databases/">Web Cloud Databases.
Helpful (0)
B

Thank you. The environment is being upgraded right now!
Helpful (0)
A

Is the MySQL upgrade still in progress? If so, how long will the process take? The MySQL version on my plan is still 5.7. Thank you very much for your support.
Helpful (0)

As described ovhcloud.com/incidents/cnf2n29hj6s1">here (which is THE place to see the progress of the upgrades), the upgrades had been paused during the Olympic Games (because that's important for some businesses, and we avoid interventions during such events). As the Olympic Games are over, the upgrades continued since 2024-08-12.
Helpful (0)
F

Hi everyone,

I'm glad to inform you that the upgrade process is now 100% finished. Every single database now runs on MySQL 8.0.

Thanks for your patience
Helpful (0)

Join discussion