Articles in this section

Which MySQL versions are supported by Plesk?

Plesk for Windows kb: how-to Plesk for Linux ABT: Group A

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

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 starting from Plesk Obsidian 18.0.33
  • MySQL Community Edition 8.2 and 8.3 is supported starting from Plesk Obsidian 18.0.59
  • MySQL Community Edition 8.4 is supported starting from Plesk Obsidian 18.0.76
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.

  1. Create a full server snapshot to have a possibility to rollback the changes.
  2. Upgrade MySQL server as described in the the MySQL documentation.
  3. 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.

  1. Install MySQL 8 as described in the MySQL documentation.
  2. 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

  3. Install Plesk.
Was this article helpful?

Comments

2 comments
Date Votes

Please sign in to leave a comment.