Openfire is a cross-platform java based free Instant Messaging server which implements the XAMPP (Jabber) protocol with extensions. openfire是一個跨平台的Java為基礎的免費的即時通訊服務器實現xampp （的Jabber ）協議的擴展。 It is very well suited as corporate instant messaging solution.這是非常適合作為企業即時通訊解決方案。 Here is how you can recover the admin password, in case you forget it.這裡是你如何可以恢復管理員密碼，如果你忘記它。


How to recover Openfire admin password如何恢復openfire管理員密碼

1. 1 。 Login to MySQL and use openfire database.登錄到MySQL和使用openfire數據庫。 I use the command:我使用的命令：
mysql -uroot -p openfire MySQL的- uroot - P的openfire

2. 2 。 Display the password for the admin user with the query:顯示管理員密碼與查詢：
select password from jiveUser where username = 'admin'; 選擇密碼從jiveuser其中username = '管理' ;

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 encryptedPassword field and cannot be recovered.之後，首先改變的密碼是加密並存儲在encryptedpassword領域和無法恢復。

However you can change the password even without knowing the original password.不過您可以更改密碼，甚至不知道原來的密碼。

How to change Openfire admin password如何改變openfire管理員密碼

Change the admin (or any other users) password by setting password field to chosen value and encryptedPassword field to null.改變政府當局（或任何其他用戶）的密碼設置密碼欄位選擇的價值和encryptedpassword領域為NULL 。 For example here is the query to set the admin password to 123456:例如在這裡是查詢設置管理員密碼123456 ：
update jiveUser set password='123456', encryptedPassword = null where username ='admin'; 更新jiveuser設置密碼= 123456 ' ， encryptedpassword =空其中username = '管理' ;

This will change the current admin password to 123456.這將改變目前管理員密碼123456 。 Remember to change it to a different value after you login to the admin console.記得將它更改為不同的值後，您登錄到管理控制台。 This will also have the side-effect of encrypting your password in database for added security.這也將有副作用加密您的密碼在數據庫中為增加安全性。

Note: Openfire admin console is available at http://localhost:9090注： openfire管理控制台可在http://localhost:9090