Complete guide to host multiple WordPress sites in a LEMP stack in a Ubuntu 16.04 LTS. Installation of SSL by Let’s Encrypt has been illustrated also.
ubuntu
How to Create Multiple SFTP User in VPS
Create multiple SFTP user in a VPS for accessing respective website folders. Access is limited to the respective folders only. Use FileZilla to access remote Host.
MySQL Commands for Hosting in Linux VPS
You need to copy olddb.sql file to your new host. You may use FTP programme to download the SQL file from old host and then upload to the new host.
Implement Sphinxsearch in phpBB
Sphinxsearch is believed to be the fastest search engine. It is very much useful for large websites. Sphinxsearch can only be installed in a Nginx server.
PHP: Missing MySQL Extension
Your PHP installation appears to be missing the MySQL extension which is required by WordPress. Run: apt-get install php5-mysql in hosting account.
Error: Unable to Resolve Hostname
After changing hostname of your VPS, you need to restart VPS (Type sudo reboot in command line). This will solve the issue, “Unable to resolve hostname”.