How to host multiple websites in a single VPS in LAMP environment. All sites will use SSL certificates (https). All commands are for shown considering Ubuntu linux.
mysql
Add Administrator of WordPress through MySQL
If you can not login to your wordpress site using administrator account in conventional methos, then you may create another administrator account using mysql commands.
Multiple WordPress with SSL in Ubuntu 16.04
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.
Remove Website Field using MySQL Command
To remove website field from comments and user profiles in a wordpress powered site you need to run the few mysql commands in the terminal window of VPS.