Based on instructions starting at SWDestinyDB.

Install MySQL

1. See https://help.ubuntu.com/lts/serverguide/mysql.html.en Ubuntu MySQL documentation.
2. See here.

1. sudo apt install mysql-client-core-5.7
2. sudo apt install mariadb-client-core-10.1
3. sudo apt install mysql-server
4. sudo service mysql stop
5. sudo mysqld_safe –skip-grant-tables
6. mysql -u root
   1. use mysql;
   2. show tables;
   3. update user set authentication_string=password('1111') where user='root';
7. sudo service mysql start

Useful commands

1. sudo netstat -tap | grep mysql
2. sudo systemctl restart mysql.service

Install PHP

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

Install Composer

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

Install SWDestinyDB from github

1. cd repositories
2. git clone https://github.com/fafranco82/swdestinydb.git
3. cd swdestinydb
4. composer install
   1. mysql:root@127.0.0.1/swdestinydb