Encountering error while running "bench new-site site1.local" on my mac machine

Thank you so much for having a look at this post! I am in the process of learning erpNext which means I am still noob and I am following the Setting up a Mac for Frappe ERPNext Development. Thank you in advance and please have a look at this issue and help me. Here is the code where the error is occurring:
I want to add this: this post has addressed the same issue but mine is on mac and I did not get what to do. because I do not have (/etc/mysql/my.cnf) in my machine.

(bench-env) ismailahmadi@Ismails-MacBook-Pro frappe-bench % bench new-site site1.local

WARN: bench is installed in editable mode!

This is not the recommended mode of installation for production. Instead, install the package from PyPI with: pip install frappe-bench

MySQL root password:

For key collation_server. Expected value utf8mb4_unicode_ci, found value utf8mb4_general_ci


Creation of your site - site1.local failed because MariaDB is not properly

configured. If using version 10.2.x or earlier, make sure you use the

the Barracuda storage engine.

Please verify the settings above in MariaDB’s my.cnf. Restart MariaDB. And

then run bench new-site site1.local again.


Database settings do not match expected values; stopping database setup.

and here is the brew list:

(bench-env) ismailahmadi@I> smails-MacBook-Pro frappe-bench % brew ls
gdbm groonga mecab-ipadic pcre readline xz
gettext mariadb msgpack pcre2 redis
git mecab openssl@1.1 python sqlite

Here is the version of Mariadb:

(bench-env) ismailahmadi@Ismails-MacBook-Pro frappe-bench % mysql --version

mysql Ver 15.1 Distrib 10.4.13-MariaDB, for osx10.15 (x86_64) using readline 5.1

The configuration for my.cnf from this link

(bench-env) ismailahmadi@Ismails-MacBook-Pro frappe-bench % cat /usr/local/etc/my.cnf



character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci


default-character-set = utf8mb4

include *.cnf from the config directory

!includedir /usr/local/etc/my.cnf.d