Changing tango database password without loosing database content

General Installation
1

Hi,
I would like to change a password for the user tango on a database.

Using dpkg-reconfigure will loose the content of the database.
Changing the password through mariadb would be a simple solution, but I would need probably to change the password somewhere else to allow tango system to connect to the database with the new password.

What are the steps to follow to change the tango database password without removing the database content?

EDIT: I already tested changing the password and then jive does not work so there is some way allowing jive to authenticate to the tango DB.
I also tested changing the password and then using dpkg-reconfigure, it reinstall the default database so all the device configured before are lost.
I also tested a dump before dpkg-reconfigure and then import the dump after dpkg-reconfigure, and it seems to work.
Is this last option the only way to do it?

Thank you.

2

Hi Philippe,

In this case, dpk-reconfigure says that a backup of the original database is made in /var/tmp if you keep the same database name.
So you should be able to restore it afterwards.

3

Yes, absolutely.
I made the dump just in case.

I wanted to know if there is a way to reset the password without needing to import explicitely the dump.

Then, I do not understand how the tools get the authentication to access the database. I would be interested to know this.