cPanel and Almalinux, can't install mariadb

elmister

Well-Known Member
Mar 2, 2004
48
3
158
According this page cPanel & WHM version 92 for CentOS 8 | cPanel & WHM Documentation

cPanel for Centos 8 (and i understand Almalinux should be the same) supports MariaDB 10.3 and system administrators have the ability to select the default database between MySQL 8 and MariaDB 10.3 only.

But during the installation i've never been asked about it, and once installed, the MySQL/mariadb upgrade option doesn't give the option to install mariadb, only mysql 8.0 is available.

Is mariadb supported by cPanel for Centos 8/Almalinux?

Is yes, how should i proceed to change mysql 8 to mariadb?

Thank you
 
Last edited by a moderator:

elmister

Well-Known Member
Mar 2, 2004
48
3
158
BTW: I see that some pages say cPanel for Centos 8 is experimental, those pages are about version 92, but that's not in the installation page. Is currently experimental ? Or can we use it in production?
 

quietFinn

Well-Known Member
Feb 4, 2006
1,841
426
438
Finland
cPanel Access Level
Root Administrator
According this page cPanel & WHM version 92 for CentOS 8 | cPanel & WHM Documentation

cPanel for Centos 8 (and i understand Almalinux should be the same) supports MariaDB 10.3 and system administrators have the ability to select the default database between MySQL 8 and MariaDB 10.3 only.

But during the installation i've never been asked about it, and once installed, the MySQL/mariadb upgrade option doesn't give the option to install mariadb, only mysql 8.0 is available.
Before you install cPanel create file /root/cpanel_profile/cpanel.config, and in that write line:
mysql-version=10.3

 
  • Like
Reactions: cPRex

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
14,307
2,238
363
cPanel Access Level
Root Administrator
The details that @quietFinn provided will let you specify the version of MySQL or MariaDB that gets installed on the machine, but that work needs to happen before the installation process starts.

CentOS 8 is no longer experimental, although you may want to review some of the drama surrounding that version of the operating system before you commit to it, as it is only supported through December of this year.
 

elmister

Well-Known Member
Mar 2, 2004
48
3
158
CentOS 8 is no longer experimental, although you may want to review some of the drama surrounding that version of the operating system before you commit to it, as it is only supported through December of this year.
But this is solved with Almalinux, isn't it? I converted it to Almalinux before installing cpanel
 

CoolMike

Well-Known Member
Sep 6, 2001
313
0
316

Kent Brockman

Well-Known Member
PartnerNOC
Jan 20, 2008
1,335
75
178
Buenos Aires, Argentina
cPanel Access Level
Root Administrator
@CoolMike - I see we just updated the article 15 days ago to explain that version Centos/AlmaLinux 8 of the operating system only works with MySQL 8 or MariaDB 10.5. The older versions would only be supported if you were using CentOS 7/CloudLinux 7.
Hello guys. Now I installed cPanel v106 on a fresh server with Almalinux 8 without knowing this and it is not providing options to upgrade to MariaDB. Only MySQL 8 is present. Even afterrunning upcp --force it is not offered as an option. Why is this working so? And why is not weird? Is it a bug?
 

Kent Brockman

Well-Known Member
PartnerNOC
Jan 20, 2008
1,335
75
178
Buenos Aires, Argentina
cPanel Access Level
Root Administrator
I'm looking and answer to upgrade MySQL to MariaDB on Almalinux 8 without reinstalling the entire OS from the top. Please provide a way to do that.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
14,307
2,238
363
cPanel Access Level
Root Administrator
MariaDB is considered a downgrade from MySQL 8, so there is no way to make that switch. If you want MariaDB on an AlmaLinx 8 machine, you'd need to set that up from the start before cPanel is installed by adjusting our installation flags as outlined here:

 
  • Like
Reactions: Kent Brockman

Kent Brockman

Well-Known Member
PartnerNOC
Jan 20, 2008
1,335
75
178
Buenos Aires, Argentina
cPanel Access Level
Root Administrator
MariaDB is considered a downgrade from MySQL 8, so there is no way to make that switch. If you want MariaDB on an AlmaLinx 8 machine, you'd need to set that up from the start before cPanel is installed by adjusting our installation flags as outlined here:

Ok replied to this on the below related thread: