Fix mariadb my.cnf issue

1

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

[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
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.

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

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]

4

which mariadb version you have?

5

ref,