ARCHIVED: MySQL 8.0 upgrade for Sitehost

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

On this page:

Overview
Timeline
Features and changes
Recommendations

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.

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.