Step :1 Decrypt the DB password

1.    Open the file PMP\conf\database_params.conf and copy the DB password which is present in the database_params.conf file (For example: Rq2+2Q9/x5atDTIaPJfP7n9eMrFAzU1E9cg=)

2.    Then You will have to decrypt the password to login to the Db using the tool present in the below link.

3.    Download the Tool from the link and extract it directly into the PMP directory.  https://downloads.zohocorp.com/dnd/PasswordManagerPro/68cl7hCU8RO5VO4/DecryptDatabasePassword.zip

4.    Then Open Cmd as an administrator and navigate to PMP\bin folder and execute the command, decryptpassword.bat <encrypeted password copied from Database_params.con file>.

5.    Now you will get the password decrypted which would be used to login to the DB.

6.     Copy the DB password in a notepad.

 

Query to be executed:

select * from ptrx_securitysettings; <<---->>   It will display the IP entries inside the table. 

Execute the delete query to remove the entries: 

delete from  ptrx_securitysettings; 

After deleting the entries, please check whether you can access the PMP web console.

注意：建议始终连接到数据库并在支持帮助下执行数据库查询。不鼓励个人行动，如果出现任何问题，PMP将不负责。在进行任何更改之前，请确保备份PMP安装目录或PMP服务器的快照。