Unable to start mariadb due DDL recovery/log [Errcode: 13]
I’m encountering an issue while trying to start MariaDB with the command sudo mariadbd-safe start. The error messages I get are:
2024-07-22 20:19:20 0 [Note] Starting MariaDB 11.4.2-MariaDB source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 3621 2024-07-22 20:19:20 0 [ERROR] mariadbd: Can't create/write to file './ddl_recovery.log' (Errcode: 13 "Permission denied") 2024-07-22 20:19:20 0 [ERROR] DDL_LOG: Failed to create ddl log file: ./ddl_recovery.log 2024-07-22 20:19:20 0 [ERROR] Aborting
It seems to be a permission issue with the file ddl_recovery.log. How can I resolve this?
Answer Answered by Daniel Black in this comment.
by giving it create/write permissions to the MariaDB data directory for the user that ends up running on the mariadbd process.
I see you've used sudo mariadbd-safe, this is probably to a mysql user.