(env) localhost-2:frappe-bench abdo$ bench new-site frappe1.local
MySQL root password:
For key collation_server. Expected value utf8mb4_unicode_ci, found value utf8mb4_0900_ai_ci
Creation of your site - frappe1.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.
(env) localhost-2:frappe-bench abdo$ cat /usr/local/etc/my.cnf
# Default Homebrew MySQL server config
[mysqld]
# Only allow connections from localhost
bind-address = 127.0.0.1
mysqlx-bind-address = 127.0.0.1
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
Output of bench version
erpnext 14.x.x-develop
frappe 14.x.x-develop
Additional information
My OS is Mac OS X , 10.15.7