====== Installing SWDatabaseDB ======

Based on instructions starting at [[https://github.com/fafranco82/swdestinydb|SWDestinyDB]].

Install MySQL

  - See [[https://help.ubuntu.com/lts/serverguide/mysql.html.en Ubuntu MySQL documentation]].
  - See [[https://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx|here]].

  - sudo apt install mysql-client-core-5.7
  - sudo apt install mariadb-client-core-10.1
  - sudo apt install mysql-server
  - sudo service mysql stop
  - sudo mysqld_safe --skip-grant-tables
  - mysql -u root
    - use mysql;
    - show tables;
    - update user set authentication_string=password('1111') where user='root';
  - sudo service mysql start

Useful commands
  - sudo netstat -tap | grep mysql
  - sudo systemctl restart mysql.service

Install PHP

  - sudo apt install php7.2-cli
  - sudo apt install hhvm
  - sudo apt install php-curl
  - sudo apt install phpoffice

Install Composer

  - Either from instructions at https://getcomposer.org/download/, or
  - Using sudo apt install composer

Install SWDestinyDB from github

  - cd repositories
  - git clone https://github.com/fafranco82/swdestinydb.git
  - cd swdestinydb
  - composer install
    - mysql://root@127.0.0.1/swdestinydb