MySQL 8.0 upgrade for IU Sitehosting

On this page:


Overview

In January 2021, the Sitehost test servers were upgraded from MySQL 5.7 to 8.0. Sitehost production servers were upgraded in February 2021. Due to compatibility issues between MySQL 8.0 and PHP 7.3 (and earlier), the upgrade to MySQL 8.0 coincided with Sitehost's upgrade to PHP 7.4.

Timeline

  • January 28, 2021: The Sitehost test server (mysql-test.uits.iu.edu) was upgraded to MySQL 8.0.
  • February 28, 2021: The Sitehost production server (mysql.uits.iu.edu) was upgraded to MySQL 8.0.

Features and changes

  • In MySQL 8.0, the preferred authentication plugin (caching_sha2_password) is more secure than MySQL's previous default authentication plugin (mysql_native_password).
  • For a full list of changes in MySQL 8.0, see the MySQL documentation.

Recommendations

  • Update websites that use full-featured solutions, like WordPress, Drupal, and MachForm, to the latest versions of the software and any installed plugins.
  • Update any software you use to connect to the MySQL for Sitehost databases, such as MySQL Workbench, to the latest version. MySQL Workbench version 8.0 or later is required to connect to MySQL 8.0 servers.

This is document bgpc in the Knowledge Base.
Last modified on 2021-03-19 09:55:47.