Initial Setup Ubuntu Server 16.04 (Nginx, Mysql, PhpMyAdmin, PHP)
First Step follow this step: here
Install necessary extension of PHP 7
sudo apt-get install php7.0-gd
sudo apt-get install php7.0-zip
sudo apt-get install php7.0-curl
Add Firewall
Follow this step: here
Add phpMyAdmin
follow this step: here
Allow for remote access mysql
-
restart mysql
sudo service mysql restart
-
add to your mysql server firewall the following rule:
sudo ufw allow from IP_FROM_YOU_CONNECT to any port 3306
-
test from your remote location with
mysql -u *USER_CREATED_BEFORE *-h *MYSQL_SERVER_IP* -p