What is the best way to change the Master Database password? I inherited this server and was not part of the original install team. Using the database management tool it's not clear which user to select and I get an access denied error as well.
Here is the top half of my .conf file hoping it helps trouble shoot the issue.
Top Half openerp-server.conf file:
addons_path = /usr/lib/python2.7/dist-packages/openerp/addons
admin_passwd = #@%^)(*#
auto_reload = False
csv_internal_sep = ,
data_dir = /var/lib/odoo/.local/share/Odoo
db_host = False
db_maxconn = 64
db_name = False
db_password = False
db_port = False
db_template = template1
db_user = odoo
The master password used by Odoo for administrative purposes is *admin_password*. This gives you permission to create, backup, restore and delete databases. If it was changed via the UI, then a file called $HOME/.openerp_serverrc is created ($HOME refers to the user starting Odoo - usually via a service) and you'll find it there in admin_password. Each database, however, potentially has it's own password that is stored inside the database, often encrypted.
Changing the master password has nothing to do with any databases. It isn't the same user. By default both logins are 'admin' but this is just a coincidence.