commit 8005022508d9c2fb718449ceb5aa7bcc3aabaca6
author Aditya Hase <aditya@adityahase.com> Thu Jul 25 21:19:30 2019 +0530
committer Aditya Hase <aditya@adityahase.com> Thu Jul 25 21:19:30 2019 +0530
tree a1884f9e02786dae798fdd7c0c6af299290ade48
parent 06ca6f7705675752540b05481056b686bc5c4dfb

fix(travis): Setup MariaDB

.travis.yml

diff --git a/.travis.yml b/.travis.yml
index 108df91..5ecede0 100644
--- a/.travis.yml
+++ b/.travis.yml
@@ -43,9 +43,15 @@
   - cp -r $TRAVIS_BUILD_DIR/.travis/site_config.json ~/frappe-bench/sites/test_site/
 
 before_script:
-  - mysql -u root -ptravis -e 'create database test_frappe'
-  - echo "USE mysql;\nCREATE USER 'test_frappe'@'localhost' IDENTIFIED BY 'test_frappe';\nFLUSH PRIVILEGES;\n" | mysql -u root -ptravis
-  - echo "USE mysql;\nGRANT ALL PRIVILEGES ON \`test_frappe\`.* TO 'test_frappe'@'localhost';\n" | mysql -u root -ptravis
+  - mysql -u root -e "SET GLOBAL character_set_server = 'utf8mb4'"
+  - mysql -u root -e "SET GLOBAL collation_server = 'utf8mb4_unicode_ci'"
+
+  - mysql -u root -e "CREATE DATABASE test_frappe"
+  - mysql -u root -e "CREATE USER 'test_frappe'@'localhost' IDENTIFIED BY 'test_frappe'"
+  - mysql -u root -e "GRANT ALL PRIVILEGES ON \`test_frappe\`.* TO 'test_frappe'@'localhost'"
+
+  - mysql -u root -e "UPDATE mysql.user SET Password=PASSWORD('travis') WHERE User='root'"
+  - mysql -u root -e "FLUSH PRIVILEGES"
 
   - cd ~/frappe-bench
   - bench get-app erpnext $TRAVIS_BUILD_DIR