How to enable MySQL® 8 with new installations

Introduction

The default SQL server installed in cPanel version 122.0.1 and higher is MariaDB® 10.11. This article provides the procedure to install MySQL® 8 durring cPanel & WHM installation.

Procedure

1. Access the server's command line as the 'root' user via SSH.
2. Create the /root/cpanel_profile folder.

   mkdir /root/cpanel_profile

3. Create the cpanel.config file in the /root/cpanel_profile folder.

   touch /root/cpanel_profile/cpanel.config

4. Open the cpanel.config file in your preferred text editor.
5. Add the following line to the cpanel.config file.

   mysql-version=8.0

6. Save the changes and exit the text editor.
7. Initiate the cPanel installation.

   cd /home && curl -o latest -L https://securedownloads.cpanel.net/latest && sh latest

Additional resources

Installation Guide - Customize Your Installation: Configuration settings

How to install cPanel