commit 185e2a2fd8926e96e0311cbaff0c95acb57f50d7
author Aditya Hase <aditya@adityahase.com> Thu Jul 25 21:19:30 2019 +0530
committer Aditya Hase <aditya@adityahase.com> Fri Jul 26 05:54:03 2019 +0530
tree ea7259229f21c7077ac6ea02e1a098b83ca9cc3a
parent e2b16e3edbebaae0746d83077eb32c226b6f9f29

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