/bin/fuser

First check your openfire.xml file located in your conf directory (example: RHEL5 is /opt/openfire/conf).

Look for the lines to give you the server’s address, database name, username and password to authenticate with.

<database>
<defaultProvider>
<driver>com.mysql.jdbc.Driver</driver>
<serverURL>jdbc:mysql://localhost:3306/openfiredb</serverURL>
<username>openfire</username>
<password>L0t0!</password>
<testSQL>select 1</testSQL>
<testBeforeUse>true</testBeforeUse>
<testAfterUse>true</testAfterUse>
<minConnections>5</minConnections>
<maxConnections>15</maxConnections>
<connectionTimeout>1.0</connectionTimeout>
</defaultProvider>
</database>

If your using the internal MySQL authentication like this example you can connect to the database via this command

mysql -u openfire -p openfiredb

Then use the password L0t0!

When your connected to the database run the following command to reset your admin password to 123456

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

Now restart your Openfire server(example: RHEL5 run /sbin/service openfire restart) and you should be able to login via the admin page with the username admin and password 123456.