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 started from Plesk Obsidian 18.0.33
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.
Comments
19 comments
Hello there,
please tell me MySQL 8.0 is on its way - also NET Core 3.0 out of the box?
kind regards
Hello @компроматkoffer,
Information about the support of MySQL 8.0 and ASP.NET Core 3.0 is not available at the moment.
Please note that ASP.NET Core 3.0 is a release candidate which didn't reach its release tear yet.
Thank you Marc for the article.
But in the meantime, can I manually install MySQL server in my CentOs 7 system in paralell with the existing Mysql 5.X that Plesk installed without breaking Plesk? I have a website which needs MySQL 8.
Please let me know.
Best wishes
Nima
@Nima,
Out of the box none of the operations systems allows to install two MySQL servers simulteniously. There are guides accors the internet how to do that manually, but we never test Plesk with such scnearious, so I cannot say if that will work for you.
The only supported option I have in mind is to use Docker and deploy MySQL 8.0 as a Docker container.
MySQL Server 8.0 was released in April 2018 - when will Plesk support it?
With so many security concerns and so many people wanting better performance I cannot believe that Plesk has not announced when they will support MySQL 8.
Does anyone have an idea when?
@William Smith not in this year. I hope we will be able to provide you with more info in Q1 2020.
Is there already more information about mysql 8 support?
Hi, i still have
System:
CloudLinux 7.7
Plesk Obsidian Version 18.0.24
Why?
I really need 8.0. The Auto increment bug when restarting the database of older MySql versions is really annoying! Please help!
Hello,
Richie Tjin and Roland Finke, currently MySQL 8 Support is planned to be released in mid Q2 2020.
Lenusch during Plesk installation SQL server is installed from OS repositories. So, the installed version depends on what SQL server version is provided by OS vendor. This article will help to install the required version: https://support.plesk.com/hc/en-us/articles/213403429
When is the release planned?
Hello, @Richie Tjin
There is no ETA currently. As soon as new version of will be fully tested with Plesk support will be available. Refer to change log
https://docs.plesk.com/release-notes/obsidian/change-log/ for updates.
This is beyond poor service now.
I started work on a statistically heavy site two years ago, which relies hugely on CTE's, thinking that in the year or so I estimated it would take me, MySQL8 would definitely be available through Plesk. It was ready at the end of last year BUT 9 months on I still cannot launch it because Plesk has still not implemented it.
I really do not want the hassle of moving to a host that uses cPanel but given that the latest estimate is still Q2 when we are nearing the end of Q3 I am assuming that, for whatever reason, MySQL8 will not be coming to Plesk in the near future.
Hello Steve Ball
Thank you for the feedback. I would certainly feel the same.
Due to technical difficulties while working on support the process indeed takes longer than desired.
There's a possibility that full support will be available in 2021 only.
Thank you for understanding.
This is absolutely ridiculous. Plesk lets its customers down on this. Same applies to in-place upgrades of Ubuntu by the way. I will need to find a hoster that uses cPanel, I am afraid.
MySQL 8 or above is mandatory to run Nextcloud 21 (release in February 2021). Support for Nextcloud 20 ends in October 2021... It is time to get MySql 8 running.
The instructions on how to upgrade from MySQL 5.7 to 8 are unfortunately as vague as the upgrade instructions to upgrade from Ubuntu 16.04 to 18.04...
So to clarify, it would be great to EXACTLY describe how to upgrade from MySQL 5.7 to 8 on Ubuntu 16.04. What is missing is especially which new packages need to be installed and how.
We have a Plesk-installation on Windows. But its time to upgrade MySQL to 8.0. I don't think we need it tied to Plesk anymore. Can I just use the MySQL upgrade instructions? And not worry about the lack of Plesk support for 8.0 on Windows.
Hello @Robert Koernke!
If MySQL server is not connected to and not managed by Plesk, you are free to use it according to the official MySQL documentation, including upgrade operations.
Instructions in this article are only about MySQL working on Plesk for Linux servers.
Please sign in to leave a comment.