Please add this to MariaDB's my.cnf and restart MariaDB before proceeding

when I’m trying to install erpnext v 6
i successfully creat the app by
$ bench get-app erpnext GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)
and when i add a new site with
$ bench new-site site1.local

i have a message that say

Please add this to MariaDB’s my.cnf and restart MariaDB before proceeding

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

default-character-set = utf8mb4

where i can find this file I’m using MAC OS X el capitan 10.11.3

How did you install MariaDB? Please Google this.

I’m using MAC OS X El Capitan

1 Install Xcode : $xcode-select --install
2 Install Homebrew : $ruby -e “$(curl -fsSL”
3 Check Homebrew : $brew update
5 Verify MariaDB Version in Homebrew Repo :$brew info mariadb
6 Install MariaDB: $brew install mariadb
7 Run the Database Installer: $unset TMPDIR
8 Start MariaDB: $mysql.server start
9 Secure the Installation: $mysql_secure_installation
10 Connect to MariaDB: $mysql -u root -p

@Badrelden_Ahmed I work on a mac as well. Could I suggest using either:


Both work well and allow you access to all Frappe files locally in OS X to edit while avoiding the hassle of having to install MariaDB and all the other dependencies in your OS X install. The first link explains how to install in Win but can be applied exactly the same in OS X.

1 Like

thanx i’s work fine for me now