Suppose, you have installed MojoPortal and after a few months you have forgot the login email which is required for accessing the administration dashboard.
The system has a facility to recover lost password.
However, in order to use this feature you require login e-mail which you used either at the time of installation or while updating the site later on.
Sometimes, you will forget password but your login e-mail id will be the default provided by the installer – email@example.com
In such a scenario, you need to dig deep into the database to find out the password as mentioned below
(1) Open SQL Server 2008 / 2012
(2) You will view a dialog named – Connect to Server
(3) Provide the database name, database username and password which you provided at the time of mojoportal installation process.
If you installed MojoPortal through Web App Gallery from within WebsitePanel then you need to search for “user.config” file from the file manager and fetch the required credentials.
(4) If the provided credentials are correct then you will be logged into SQL Server. Locate your database from the navigation panel located on the left hand side.
(5) Expand the database name, then Tables and locate the table name – dbo.mp_Users
(6) Right click on the above mentioned table and select the option – Select Top 1000 Rows
(7) SQL Server will display the list of entries under each column. By default, it will only show details of Admin user. However, you will view more entries if your site is bit old and users have registered on the site.
(8) In order to view the password of admin user, you need to scroll horizontally until you see the column name – Pwd.
It is to be noted that MojoPortal displays passwords as such without any kind of encryption. Hence, you should use very strong password for the database, FTP and administrator user account.