How to reset Openfire admin login

This article explains the detailed steps to reset the openfire administrator password.

Step1: Find the openfire database name from the configuration file '/opt/openfire/conf/openfire.conf'

Step2: Login to MySQL and use openfire database.

Step3: Display the password for the admin user

#select password from ofUser where username = ‘admin’;

The encryptedPassword field is your admin’s password.

Step4: Change the admin (or any other users) password by the below command

#update ofUser set plainPassword='newpassword', encryptedPassword=null where username='admin';