Applicable to:
- Plesk for Linux
- Plesk for Windows
Question
Which MySQL versions are supported by different versions of Plesk?
Answer
Plesk Obsidian Windows:
- MySQL 5.1–5.7
- MySQL community edition 5.5, 5.6, 5.7
- MySQL 8.0 as remote server only
Plesk Obsidian for Linux:
- MySQL 5.1–5.7
- MySQL community edition 5.5, 5.6, 5.7
- MySQL 8.0 is supported started from Plesk Obsidian 18.0.33
MySQL 8 community-server was tested on all supported OSes (Plesk for Linux Supported Operating Systems)
MySQL 8 from OS distributive was tested on Ubuntu 20.04 and CentOS 8 / RHEL8
To perform upgrade Plesk local database server to MySQL8
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 full server snapshot to have possibility rollback the changes.
- Upgrade MySQL server according to https://dev.mysql.com/doc/refman/8.0/en/upgrading.html
- Additional step for RPM-based OS (CentOS and RHEL). Install Plesk dependency package:
for CentOS 7:# rpm -Uvh https://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-7.rpm
For CentOS 8:# rpm -Uvh https://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-8.rpm
To perform clean installation of Plesk on the server with MySQL8
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.
Before installation of Plesk on RPM-based OSes (CentOS and RHEL). Install Plesk dependency package:
for CentOS 7:
# rpm -Uvh https://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-7.rpm
For CentOS 8:
# rpm -Uvh https://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-8.rpm
Plesk Onyx for Windows:
The following versions are included in Plesk distribution packages:
- MySQL community edition 5.5.55 (for Plesk database)
- MySQL community edition 5.6.39 (for customer websites)
- MySQL community edition 5.7.21 (for customer websites)
The following versions are supported:
- MySQL community edition 5.5, 5.6, 5.7
Plesk Onyx for Linux:
- MySQL 5.1–5.7
- MySQL community edition 5.5, 5.6, 5.7
Comments
16 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.
Lenor 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.
Please sign in to leave a comment.