I tried to used remote database server. I have read this How can I migrate mysql to remote server - #11 by Jonathan_Fanny_Lie.
as per instruction
bench --force --site site1.local restore /home/ubuntu/frappe-bench/sites/site1.local/private/backups/20151219_67776697_database.sql.gz
but I always got this response
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
which I do not have access to my.cnf.
Any ideas how to resolve this issue?