Install database server (ubuntu 18.10)

This post describes how to install some popular database server on ubuntu 18.10.

Actually, I’m using a separate machine with VMWare Ubuntu 18.10-live-server for the database server. I do not focus so much detail in each database engine, just how to set up and test the connection. More detail you just learn more yourself.

Below is the connection config to each database server after install.

DB-Server
Config: 
* OS Ubuntu 18.10
* Server name: database
* SSH address: nhancao@172.16.100.159
MongoDB
* Host: 172.16.100.159
* Port: 27017
MySQL
* Host: 172.16.100.159
* Port: 3306
* Root account: root/Root@123 (localhost only)
* Admin account: admin/Admin@123 (% anywhere)
PostgreSQL
* Host: 172.16.100.159
* Port: 5432
* Database: defaultdb
* Account: admin/admin@123

MongoDB v4.0.3

Free 500MB mongoDB:
- https://mlab.com/
- https://www.mongodb.com/cloud/atlas

Install: https://docs.mongodb.com/manual/tutorial/install-mongodb-on-ubuntu/

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 9DA31620334BD75D9DCB49F368818C72E52529D4
echo "deb [ arch=amd64 ] https://repo.mongodb.org/apt/ubuntu bionic/mongodb-org/4.0 multiverse" | sudo tee…