Reset Openfire Admin account

If you ever forget your OpenFire admin password you can simply go into the SQL Database and run the following command. Of course you want to change out “123456” to a password that you want

update ofUser set plainPassword=’123456′, encryptedPassword=NULL where username=’admin’;