Please verify the settings above in MariaDB's my.cnf

(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
# Only allow connections from localhost
bind-address =
mysqlx-bind-address =
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

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

@Abdullah_Yassin looks good.

refer to this link if any query :Installation