14

Does anyone know how can I reset the username and password for CouchDB ?

mannoj
  • 443
  • 2
  • 5
  • 18
linktoarun
  • 203
  • 1
  • 2
  • 6

11 Answers11

21

This worked for me: while couchdb is stopped,

  1. clear the [admin] section in your */etc/couchdb/local.ini
  2. delete the _users.couch database (located in */var/lib/couchdb/)

This will reset the user database to factory defaults (admin party!) and wipe all of couchdb's user accounts. There might be a more subtle way

user2378197
  • 760
  • 7
  • 11
  • 3
    Works great, thanks a lot. A word of WARNING: This is very useful for development and test databases without any real users. If you do this on a production database all your user accounts will be gone, which is a BAD thing ;) –  Jun 09 '13 at 20:46
  • I did that, how do i restart the couchdb now. It still says you are not an admin when trying to restart db using curl – Utsav Gupta Mar 05 '15 at 23:54
18

With Apache CouchDB, admin accounts passwords can be changed by editing a file local.ini in the CouchDB config folder (/etc/couchdb/ on most Linux installs). [1]

Look for the [admin] section, which will list the all admin usernames, along with their hashed passwords:

[admin]
foo = -pbkdf2-0e0e83f911c970565fc988497a657bdc21a005e8,19ecef0bea1caf8d7f08fb791379c686,10

Replace the password hash with a new clear text password:

foo = bar

Now restart CouchDB (sudo restart couchdb on Ubuntu). CouchDB will notice the clear text password on startup and automatically replace it with the hashed version.

Eric Drechsel
  • 2,694
  • 2
  • 23
  • 24
6

What I've done it's quite simple. I found out my old username and password here:

/opt/couchbase/var/lib/couchbase/config/config.dat

After that I went to opt/couchbase/bin/ and run

./couchbase-cli cluster-init -c localhost:8091 -u old_user -p old_password --cluster-init-username=new_user --cluster-init-password=new_password

Done! Also you can check this: http://www.couchbase.com/docs/couchbase-manual-2.0/couchbase-faq.html

vtemian
  • 103
  • 1
  • 9
3

For mac users, base folder is /Library/Application Support/couchdb

rajnish
  • 809
  • 8
  • 5
2

One more point to add ...

If you are running Couch DB on Windows, then probably it was installed as a service and to reset it you need to stop service first, within running service other answers do not work.

http://www.7tutorials.com/what-are-windows-services-what-they-do-how-manage-them

Open Control Panel - Administrative Tools - Services and stop Apache Couch DB

Anonymous
  • 1,823
  • 2
  • 35
  • 74
1

for Unix: http://silviud.blogspot.com/2012/10/couchbase-recover-web-console-password.html

/opt/couchbase/bin/erl \
-noinput -eval \
'case file:read_file("/opt/couchbase/var/lib/couchbase/config/config.dat") of {ok, B}  ->     io:format("~p~n", [binary_to_term(B)]) end.' \
-run init stop | grep cred
ConAim
  • 61
  • 3
1

You just need to add the username and password in CouchDB local.ini file. You can add as many administrators as you want.

sudo nano /etc/couchdb/local.ini

and in the end of file, add username and password.

And don't forget to restart the CouchDB server. sudo service couchdb restart

Sam
  • 11
  • 4
0

On Mac OS X, cbreset_password is not in PATH by default, so I've done just:

"/Applications/Couchbase Server.app/Contents/Resources/couchbase-core/bin/cbreset_password" 127.0.0.1:8091

...and re-set the password once confirming yes

igraczech
  • 2,408
  • 3
  • 25
  • 30
  • The cli has since been removed and replaced with `couchbase-cli`. Use this one instead, supply "newpassword": `$> /Applications/Couchbase Server.app/Contents/Resources/couchbase-core/bin/couchbase-cli reset-admin-password --new-password newpassword` – RudyD Oct 23 '19 at 16:16
0

You can change couchbase localhost password by using following steps: 1. Install crul(for windows) 2. curl -u Administrator:password http://localhost:8091/controller/changePassword -d password=admin123

sudar
  • 1,446
  • 2
  • 14
  • 26
0

ubuntu 20.04 :

apt purge couchdb

apt install couchdb

was the only thing that worked for me.

Mohnish
  • 1,010
  • 1
  • 12
  • 20
0

If using 3.2, CouchDB server administrators and passwords in the last [admins] section that CouchDB finds when loading its ini files:

  • /opt/couchdb/etc/local.ini or
  • /opt/couchdb/etc/local.d/10-admins.ini

Don't forget to restart CouchDB: sudo systemctl restart couchdb (if using ubuntu)

source: https://docs.couchdb.org/en/3.2.0/config/auth.html

Misbah
  • 36
  • 5