Hello,
I’m having issues every time if I restart mac. I’m not able to start MariaDB because of the am having issues with frappe. Can someone please help me out, tried with Gen AI and stack overflow but no luck.
# Start mariab DB with below command
sudo mariadbd-safe start
# Login into mysql console
sudo mysql -u root -p
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
# my.cnf config file
#
# This group is read both by the client and the server
# use it for options that affect everything
[client-server]
!includedir /opt/homebrew/etc/my.cnf.d
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
bind-address = 127.0.0.1
tmpdir = /tmp
socket = /tmp/mysql.sock
innodb_force_recovery = 1
[mysql]
default-character-set = utf8mb4
# Log from error file
2024-08-08 18:50:26 0 [Note] Starting MariaDB 11.4.2-MariaDB source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 71117
2024-08-08 18:50:26 0 [ERROR] mariadbd: Can't create/write to file './ddl_recovery.log' (Errcode: 13 "Permission denied")
2024-08-08 18:50:26 0 [ERROR] DDL_LOG: Failed to create ddl log file: ./ddl_recovery.log
2024-08-08 18:50:26 0 [ERROR] Aborting