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