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
bench new-site site1.localagain.
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 email@example.com 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