Reset lost farm passphrase SharePoint 2013

When administrating SharePoint server there would be many situations where we accidentally get disconnected with the SharePoint server farm. Finding the solution on how to get connected back to the lost SharePoint sites, we open the SharePoint product Configuration wizard and start to connect back to the existing farm. Very next we remember that we do not have the SharePoint farm passphrase.

The option of resetting passphrase will only work when you are connected to the farm. It is done through Sharepoint powershell commands

Get-Help Set-SPPassPhrase -Detailed
$Passphrase=ConvertTo-SecureString -String "1qaz2wsxE" -asPlainText -Force
Set-SPPassPhrase -PassPhrase $Passphrase -confirm
Confirm the Passphrase

But assuming that we already got disconnected without the passphrase being stored. There are still hopes as long as the wss_content database of the earlier site is available in the sql server. want to know how? follow the steps below.

Open up SharePoint product Configuration wizard
Click yes on Reset services>Next
Connect to Server Farm
Specify database setting and create new database name except the earlier i.e.'Sharepoint_config'
Review the setting and Click Next
It will take approx 10 minutes time to configure new farm setting.

Login to the Central Administration with Administrator Login details.

Go to Application Management>Manage Applications
Create new application and put the details as per your requirement. On the same page there is a  database setting where you will have to mention the name of your original database. It normally is 'wss_content' or 'wss_content_xxxxxx'. A Pop up of Completing successfully will give the new web application listed. This is the same site that you have lost.