[MariaDB] Errcode: 13 Permission denied

이것 저것 테스트 한다고 그런지는 모르겠는데 MariaDB가 저도 모르게 죽어있더군요~

[root@localhost conf.d]# systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.

[root@localhost conf.d]# systemctl status mariadb
× mariadb.service - MariaDB 10.5 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
     Active: failed (Result: exit-code) since Tue 2025-04-29 16:24:03 KST; 2s ago
   Duration: 14h 44min 32.176s
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 149360 ExecStartPre=/usr/libexec/mariadb-check-socket (code=exited, status=0/SUCCESS)
    Process: 149382 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
    Process: 149417 ExecStart=/usr/libexec/mariadbd --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
   Main PID: 149417 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 128ms

Apr 29 16:24:03 localhost systemd[1]: Starting MariaDB 10.5 database server...
Apr 29 16:24:03 localhost mariadb-prepare-db-dir[149382]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Apr 29 16:24:03 localhost mariadb-prepare-db-dir[149382]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Apr 29 16:24:03 localhost mariadbd[149417]: 2025-04-29 16:24:03 0 [Warning] Can't create test file '/var/lib/mysql/localhost.lower-test' (Errcode: 13 "Permission denied")
Apr 29 16:24:03 localhost systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Apr 29 16:24:03 localhost systemd[1]: mariadb.service: Failed with result 'exit-code'.
Apr 29 16:24:03 localhost systemd[1]: Failed to start MariaDB 10.5 database server.

# ls -l /var/lib/
drwxr-xr-x. 16 systemd-coredump mysql          4096 Apr 28 15:49 mysql

소유권이랑 퍼미션이 바뀌어있네요~

다시 변경해줍니다.

[root@localhost conf.d]# chown -R mysql:mysql /var/lib/mysql
[root@localhost conf.d]# chmod 755 /var/lib/mysql
[root@localhost conf.d]# systemctl restart mariadb