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

1

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

[mysqld]
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

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

2

How did you install MariaDB? Please Google this.

3

I’m using MAC OS X El Capitan

1 Install Xcode : $xcode-select --install
2 Install Homebrew : $ruby -e “$(curl -fsSL https://raw.github.com/Homebrew/homebrew/go/install)”
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

4

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

or

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
5

thanx i’s work fine for me now