How to recover Openfire admin password
Hits:138
1. Login to MySQL and use openfire database. I use the command:
mysql -uroot -p openfire
2. Display the password for the admin user with the query:
select password from jiveUser where username = 'admin';
This will display the initially chosen password for admin. However if you have at any time changed the password from the administration screen then it will display NULL instead.After first change the password is encrypted and stored in the encrypted Password field and cannot be recovered.