diff options
| author | git-marijus <mario@mariovavti.com> | 2017-05-07 15:06:45 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-05-07 15:06:45 +0200 |
| commit | bd3708870d04bd59d3a632945d1f4ff63640afe8 (patch) | |
| tree | 783a4dc2f9e9e3bd915b5e38133e53e9a387f057 /tests/travis/prepare_mysql.sh | |
| parent | 2aa699d03e17091b92c55da0b16833b299b0d081 (diff) | |
| parent | f162508ad18b1fca9a5201f4956d52022bd941a8 (diff) | |
| download | volse-hubzilla-bd3708870d04bd59d3a632945d1f4ff63640afe8.tar.gz volse-hubzilla-bd3708870d04bd59d3a632945d1f4ff63640afe8.tar.bz2 volse-hubzilla-bd3708870d04bd59d3a632945d1f4ff63640afe8.zip | |
Merge pull request #756 from dawnbreak/QA_testing
:construction_worker::white_check_mark::bug: Import table structure in TravisCI.
Diffstat (limited to 'tests/travis/prepare_mysql.sh')
| -rwxr-xr-x | tests/travis/prepare_mysql.sh | 11 |
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;" |