Mariadb start fail

Hello,

I am reaching out to you because I recently changed my linux server for a new one and after installing Mariadb on it while at the same time, adding a database for one of my site from my old server, I can't make Mariadb start properly.

I have been trying to find an answer for hours now and I've searched all over the internet and tried many different things but none of them seem to work.

I get this error log from "journalctl -xeu mariadb.service" :

déc. 07 19:25:52 P-KSWEB-A-01 systemd[1]: Starting MariaDB 11.1.3 database server... déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [Warning] Can't create test file '/var/lib/mysql/P-KSWEB-A-01.lower-test' (Errcode: 13 "Permission denied") déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [Note] Starting MariaDB 11.1.3-MariaDB-1:11.1.3+mariaubu2204 source revision 0f5613a25f27b8034645226a48c2dc1aa4562281 as process 4713 déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [ERROR] mariadbd: Can't create/write to file './ddl_recovery.log' (Errcode: 13 "Permission denied") déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [ERROR] DDL_LOG: Failed to create ddl log file: ./ddl_recovery.log déc. 07 19:25:52 P-KSWEB-A-01 mariadbd[4713]: 2023-12-07 19:25:52 0 [ERROR] Aborting déc. 07 19:25:52 P-KSWEB-A-01 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE déc. 07 19:25:52 P-KSWEB-A-01 systemd[1]: mariadb.service: Failed with result 'exit-code'. déc. 07 19:25:52 P-KSWEB-A-01 systemd[1]: Failed to start MariaDB 11.1.3 database server. déc. 07 19:31:41 P-KSWEB-A-01 systemd[1]: Starting MariaDB 11.1.3 database server...

and this one when checking at "systemctl status mariadb" :

× mariadb.service - MariaDB 11.1.3 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Thu 2023-12-07 19:31:41 CET; 21h ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Process: 4894 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 4895 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 4897 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 4926 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Main PID: 4926 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" CPU: 75ms

Would you please have an idea of what might cause this and how to resolve it ?

Thank you so much in advance for your help and have a beautiful day.

Kind Regards, ml25