Fix mariadb my.cnf issue

so after spending almost 2 days i have now fixed this error

and now i have another issue, after i run “bench --site erp.local install-app erpnext” i get this error

_mysql_exceptions.ProgrammingError: (1146, “Table ‘c6d2cec0a2672282.tabdefaultvalue’ doesn’t exist”)

and when i try “bench --site erp.local --force reinstall” it says

➜ frappe-bench bench --site erp.local --force reinstall

This will wipe your database. Are you sure you want to reinstall? [y/N]: y

Please add this to MariaDB’s my.cnf and restart MariaDB before proceeding

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

default-character-set = utf8mb4


i have added the above lines to my.cnf but i still get the same error so i assume im not on the correct my.cnf file

im on mac and i installed mariadb with brew, how do i make sure if the correct my.cnf is loading or how do i find the my.cnf file location.

frappe@erpnext:~/frappe-bench$ find /etc -name my.cnf

I beg your pardon, I’m absolutely new to frappé. Should I add those lines (Barracuda ones) to the ones already there? or replace them? In both sections [mysqld] and [mysql]

which mariadb version you have?