Post en français ici.
TL;DR: Older versions of Drupal does not work with MySQL 8.0. Update now.
---
Brace yourself, MySQL 8.0 is coming soon on the databases delivered with your web hostings, also called "SharedSQL" (more info soon). After my post on old Wordpress, this one is about old Drupal.
**Issue**
Whether you installed it yourself or using the one-click modules (CMS pre-installed by OVHcloud), if your Drupal is older than 5 years, you may be impacted by the MySQL 5.7 to 8.0 upgrade. This post is for you!
MySQL 8.0 support for Drupal depends on the Drupal major version:
* Drupal 6 is no longer supported since February 2016 (source). As MySQL 8.0 came long after that, Drupal 6 does not support MySQL 8.0. Same for the versions older than Drupal 6.
* Drupal 7, that will no longer be supported on January 2025 (source), supports MySQL 8.0 since version 7.76 (source).
* Drupal 8 supports MySQL 8.0 since version 8.6.0 (source).
* All versions of Drupal 9, 10 and 11 support MySQL 8.0.
* Drupal 11 no longer support MySQL 5.7 ; MySQL 8.0 is mandatory (source).
**Solution**
In 1 word: upgrade.
If you use…
* Drupal 6 or lower, then a major upgrade to Drupal 7 minimum is required. My advise would be to use the last Drupal 7 version: the 7.100 (source) ; There is no added value of using an older one
* Drupal 7 < 7.76, then upgrade to the latest Drupal 7: the version 7.100.
* Drupal 8 < 8.6.0, then upgrade to the latest Drupal 8: the version 8.9.20 (source).
* Drupal 7 >= 7.76, Drupal 8 >= 8.6.0, Drupal 9 or 10, you're good. 😎 🍸 🏖
Last, if you want to upgrade to Drupal 11, you can do it right now if you use a Web Cloud Database (CloudDB), but you have to wait if you use a SharedSQL.
Mikaël
MySQL 8.0: Prepare your old Drupal
Sujets apparentés
- Serveur non sécurisé, celui-ci ne supporte pas FTP sur TLS
63971
03.09.2018 14:46
- Connexion à mon compte client
58120
13.02.2019 09:51
- reCAPTCHA erreur pour le propriétaire du site : clé de site non valide
50062
14.02.2019 16:17
- [FAQ] Comment mettre à jour mon site pour supporter Apache 2.4 ?
34353
28.07.2017 11:39
- Ce site est inaccessible Impossible de trouver l'adresse DNS du serveur
29804
16.10.2016 16:24
- Augmenter taille PHP Post Max Size sur mutualisé ?
28272
04.12.2019 21:52
- The requested URL / was not found on this server
27867
02.03.2017 18:25
- NextCloud sur mutualisé
27230
07.04.2017 08:42
- Deploy d'un projet Node JS
27085
12.10.2016 20:18
- Passage en php 7.4
24857
30.06.2020 05:05