MariaDB in AlmaLinux 10 Repo is Buggy

MariaDB v10.11.11 available in Almalinux 10 is buggy. It doesn’t starts at all.

I checked the discussion regarding it on other forums and found that MariaDB has already fixed that bug in further version.

While the latest version is v10.11.13, AlmaLinux repo provides 10.11.11 which is buggy and doesn’t works at all.

Likewise, I could have used official repo provided by MariaDB[dot]org but the problem is that they don’t have repos for EL10 currently.

Now, I found the same problem is in mysql8.4 in Almalinux 10, it’s buggy and doesn’t works at all same like MariaDB 10.11.11.

To all who are struggling with this, I solved it in the following way:

nano /etc/my.cnf.d/mariadb-server.cnf

//then comment the following lines:
[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mariadb/mariadb.log
#pid-file=/run/mariadb/mariadb.pid

nano /usr/lib/systemd/system/mariadb.service

On the following line remove $MYSQLD_OPTS $_WSREP_NEW_CLUSTER

ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER

To,
ExecStart=/usr/sbin/mariadbd

Leave the rest as same