How to change Database credentials

Openfire Openfire Support
1

I have created a new user on my mysql server that i want openfire to use to connect to the database.

I was in the openfire.xml file to cange the username and password, but noticed that it was encrypted.

bc18f4fd29b6e45410f6e1e8ae5ec5eb8kca2009bde5e55f9

93fbdb0fda293e0b86f261a2f4c2cc1e87jke000966b6c3fe041e84e2371c2 5866

How do i change my database credentials to the new account i have created?

2

I think you should use this command in mysql console:

mysql> CREATE user “yournewUser”@”localhost”;

mysql> GRANT ALL ON openfireDatabase.* TO ‘yournewUser’@’localhost’ IDENTIFIED BY ‘yourPassword’;

mysql> FLUSH PRIVILEGES;

3

Sorry for not being clear.

All of that is done, i am wondering how i enter/encrypt my new user info so i can enter it into the openfire.xml.

4

Please stop the server, change .xml from

OLD_USERNAME

OLD_PASSWORD

to

NEW_USERNAME

NEW_PASSWORD

and start the server again, it will encrypt new credentials automatically.