Setting up a Wordpress Site NGINX and MySQL
I am writing this blog post to remind myself how I was able to set up a wordpress site running on VirtualBox, Ubuntu 16.04, NGINX and MySQL as its database server.
Firstly, I forgot my root's password to access MySQL, so I googled for a way to reset the password.
I realized that there is a difference in resetting the password depending on the version of the mysql server. URL: http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
When I was able to recover access in MySQL, I proceeded on to setup PHP 7 FPM to run with NGINX. I already installed PHP 7 before, so I only need to setup PHP7-FPM. To set up a socket connection with NGINX, you must have a pool for every site.
Important to modify in a pool config are:
user, group, listen.the listen config must be the same socket file in absolute path in the NGINX config.
user and group (I don't know why) is a linux user and group.