aboutsummaryrefslogtreecommitdiffstats
path: root/tests/travis/prepare_mysql.sh
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2017-05-07 14:43:38 -0700
committerzotlabs <mike@macgirvin.com>2017-05-07 14:43:38 -0700
commit8c38841a4dbc1a8daca2cfce12a295f467ecbb68 (patch)
tree6d8404008829fa4287090b5f229f0150514b6005 /tests/travis/prepare_mysql.sh
parent2c2ee706ac84926ceca21f5a4522034eb1b67d54 (diff)
parentbd3708870d04bd59d3a632945d1f4ff63640afe8 (diff)
downloadvolse-hubzilla-8c38841a4dbc1a8daca2cfce12a295f467ecbb68.tar.gz
volse-hubzilla-8c38841a4dbc1a8daca2cfce12a295f467ecbb68.tar.bz2
volse-hubzilla-8c38841a4dbc1a8daca2cfce12a295f467ecbb68.zip
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
Diffstat (limited to 'tests/travis/prepare_mysql.sh')
-rwxr-xr-xtests/travis/prepare_mysql.sh11
1 files changed, 10 insertions, 1 deletions
diff --git a/tests/travis/prepare_mysql.sh b/tests/travis/prepare_mysql.sh
index 92c720205..b3d84253c 100755
--- a/tests/travis/prepare_mysql.sh
+++ b/tests/travis/prepare_mysql.sh
@@ -36,4 +36,13 @@ mysql -e "SHOW VARIABLES LIKE 'character_set%';"
mysql -e "SELECT @@sql_mode;"
# Create Hubzilla database
-mysql -e "CREATE DATABASE IF NOT EXISTS hubzilla;" -uroot;
+mysql -u root -e "CREATE DATABASE IF NOT EXISTS hubzilla;";
+mysql -u root -e "CREATE USER 'hubzilla'@'localhost' IDENTIFIED BY 'hubzilla';"
+mysql -u root -e "GRANT ALL ON hubzilla.* TO 'hubzilla'@'localhost';"
+
+# Import table structure
+mysql -u root hubzilla < ./install/schema_mysql.sql
+
+# Show databases and tables
+mysql -u root -e "SHOW DATABASES;"
+mysql -u root -e "USE hubzilla; SHOW TABLES;"