Maria DB configuration

After installing frappe i tried to add site, I am getting this info what i want to do?
I need help regarding mariadb.

Try doing this MariaDB conf for Frappe · frappe/bench Wiki · GitHub, and don’t forget to restart mariadb after saving the file.

You need to edit my.cnf file.
Go to /etc/mysql/ and edit my.cnf and add following content

[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

and don’t forgot to restart maria db

How can i open my.cnf file ? please provide the instruction step by step.
Means how can i go to /etc/mysql/ in terminal ?
Please help me,i am new to ERPnext.


I have tried ,I am getting these error.


I have tried but got this error.

Try sudo nano /etc/mysql/my.cnf and editing it.


I got this window how to edit my.cnf file.There is no information regarding barracuda.

After copying the configration from the first photo>> go to the last line and press CTRL+SHIFT+V
Then CTRL+O Then CTRL_M to save
Then CTRL+X to exit

Simply paste this at the end of the file. Notice in line 1 its specified innodb-file-format=barracuda - hope this solves your issue

1 Like

Thank you for the usefull information.Thank you very much.

Ihave entered CTRL+O
Then it’s asking what to do next??

CTRL_M command is not working it’s asking like this

Can i save file under different name??

after ctrl+O the file is saved . you just have to exit the console pressing ctrl+X

copy the following by selecting this text below and doing ctrl v

[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

Open terminal by pressing ctrl + Alt + T
then in the prompt put sudo nano /etc/mysql/my.cnf press enter

The press down arrow to got to last line and do ctrl + shift + v

Then press Ctrl + X then Press Y

Then do systemctl restart mariadb

Hope that covers everything.

2 Likes

It is worked fine for me in ubuntu 16.4.
Try to search for the right way according to your ubuntu version,