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.
How do i change my database credentials to the new account i have created?
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;
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.
Please stop the server, change .xml from
and start the server again, it will encrypt new credentials automatically.