Question
Which MySQL versions are supported by different versions of Plesk?
Answer
Plesk Obsidian for Windows:
- MySQL community edition 5.7
- MySQL 8.0 as remote database server only
Plesk Obsidian for Linux:
- MySQL 5.7
- MySQL community edition 5.7
- MySQL 8.0 is supported started from Plesk Obsidian 18.0.33
Important notices about using MySQL 8.0 with Plesk
MySQL 8 community-server was tested on all supported operating systems (Plesk Obsidian for Linux Supported Operating Systems).
MySQL 8 from OS vendor was tested on Ubuntu 20.04 and CentOS/RHEL 8.
To perform upgrade of the Plesk local database server to MySQL 8
Note: Direct upgrade to MySQL 8.0 supported only from MySQL 5.7.9 and above. It is recommended to have the latest 5.7.x version before the upgrade.
- Create a full server snapshot to have a possibility to rollback the changes.
- Upgrade MySQL server as described in the the MySQL documentation.
- Additional step for RHEL-based OS (CentOS/RHEL/CloudLinux/AlmaLinux) - install the Plesk dependency package:
for OS based on RHEL 7:# rpm -Uvh https://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-7.rpm
for OS based on RHEL 8:
# rpm -Uvh https://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-8.rpm
To perform clean installation of Plesk with MySQL 8
Note: Since Plesk Obsidian for Linux uses PHP 7.3, during installation of Plesk, default authentication type will be switched from caching_sha2_password
to mysql_native_password
to be compatible with PHP version lower than 7.4.
- Install MySQL 8 as described in the MySQL documentation.
- For RHEL-based OS (CentOS/RHEL/CloudLinux/AlmaLinux) - install the package
mariadb-connector-c
(for RHEL 8-based OS only) and Plesk dependency package:
for OS based on RHEL 7:# rpm -Uvh https://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-7.rpm
for OS based on RHEL 8:
# dnf install mariadb-connector-c && rpm -Uvh https://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-8.rpm
- Install Plesk.