Mongodb + Atlas: 'bad auth Authentication failed.', code: 8000,

Question

I have the following error with Mongodb + Atlas:

MongoError: bad auth Authentication failed.
    at /Users/cyrus/Documents/Code/01. Code/Franklin-ford/franklin-ford-server/node_modules/mongodb-core/lib/auth/auth_provider.js:46:25
    at /Users/cyrus/Documents/Code/01. Code/Franklin-ford/franklin-ford-server/node_modules/mongodb-core/lib/auth/scram.js:215:18
    at Connection.messageHandler (/Users/cyrus/Documents/Code/01. Code/Franklin-ford/franklin-ford-server/node_modules/mongodb-core/lib/connection/connect.js:334:5)
    at Connection.emit (events.js:203:13)
    at processMessage (/Users/cyrus/Documents/Code/01. Code/Franklin-ford/franklin-ford-server/node_modules/mongodb-core/lib/connection/connection.js:364:10)
    at TLSSocket.<anonymous> (/Users/cyrus/Documents/Code/01. Code/Franklin-ford/franklin-ford-server/node_modules/mongodb-core/lib/connection/connection.js:533:15)
    at TLSSocket.emit (events.js:203:13)
    at addChunk (_stream_readable.js:295:12)
    at readableAddChunk (_stream_readable.js:276:11)
    at TLSSocket.Readable.push (_stream_readable.js:210:10)
    at TLSWrap.onStreamRead (internal/stream_base_commons.js:166:17) {
  ok: 0,
  errmsg: 'bad auth Authentication failed.',
  code: 8000,
  codeName: 'AtlasError',
  name: 'MongoError',
  [Symbol(mongoErrorContextSymbol)]: {}

Here's how I instantiate my DB:

From the credentials.js:

const config = {
    mongoConnectionURL: "mongodb://cyruslk:<MY_PASS_HERE>@franklinford-shard-00-00-3dveb.mongodb.net:27017,franklinford-shard-00-01-3dveb.mongodb.net:27017,franklinford-shard-00-02-3dveb.mongodb.net:27017/test?ssl=true&replicaSet=FranklinFord-shard-0&authSource=admin&retryWrites=true&w=majority",
    mongoDatabaseName: "FranklinFord",
  }

From my main server.js app:

const {MongoClient} = require("mongodb");
const connectionURL = config.mongoConnectionURL;
const databaseName = config.mongoDatabaseName;


  let sendToDb = (dataToInsert) => {
    MongoClient.connect(connectionURL, {
      useNewUrlParser: true,
    }, (error, client) => {

      if(error){
        console.log(error);
        return console.log("Unable to connect to the db.");
      }
      const db = client.db(databaseName);
      console.log(db);

      db.collection("ford_twitter").insertOne({
        masterData: dataToInsert
      }, (error, result) => {
        if(error){
          return console.log("unable to insert users");
        }
        console.log("Data successfully inserted");
      })
    })
  }

You can find the code here

Thanks for helping me. I have no idea what's happening.

first thing I would try is run `mongo yourfullconnectionstring` from terminal. This will tell you if problem is with code or setup — Ashish Modi, Feb 01 '20 at 19:31
I hope you saw this note? `If the username or password includes the at sign @, colon :, slash /, or the percent sign % character, use percent encoding.` — Matt Clark, Feb 01 '20 at 19:35
@MattClark I saw - but my password does not includes any of these — cyruslk, Feb 01 '20 at 22:50
Does this answer your question? [Error Message: MongoError: bad auth Authentication failed through URI string](https://stackoverflow.com/questions/55695565/error-message-mongoerror-bad-auth-authentication-failed-through-uri-string) — Valijon, Feb 01 '20 at 23:47
@Valijon no, I'm sure it's the right password and this password is the one I use for the account — cyruslk, Feb 01 '20 at 23:58

score 20 · Answer 1 · answered Feb 07 '21 at 21:09

20

I just had this problem knowing that I was using the correct username, password and DBname.

I tried to change the password for the db user to double check, but it still didn't work.

I then instead created a new user, gave the user admin role, set the password etc, and then used that new user and password (same dbname) for the connection and it worked.

I don't know exactly what the issue was, but hoping it can help some of you save some time :)

Good luck!

answered Feb 07 '21 at 21:09

IndustryDesigns

1,308
2
7
20

Not sure the problem with the default user, but creating new user worked for me as well. – Lohith Feb 09 '21 at 09:59
1

Not at all clear why, but this solved it. – hugoncosta Apr 26 '21 at 19:24
Piling on here that this solved my instance of this issue. Alas, it is unsatisfying as I would like to understand _why_. If anyone has insight please share. – Gibron Oct 28 '21 at 20:55
Thank you. I was frustrated after trying for hours.. – jatin grover May 25 '22 at 09:33

score 19 · Accepted Answer · edited Nov 15 '20 at 21:11

19

I had same problem, in that connection string it was written "mongodb+srv://<username>:<password>@cluster0.4h226.mongodb.n..." and you are supposed to enter username and password in that string.

suppose my username is "user" and password is password, we are supposed to write "mongodb+srv://user:password@cluster0.4h226.mongodb.n...", without "<" and ">";
If there are any special characters in your password, replace them with their ascii code preceded by the % sign. For example, # would be %35.

edited Nov 15 '20 at 21:11

Ruben Helsloot

11,812
5
19
40

answered Nov 15 '20 at 16:08

Nikhil Thorat

206
3
3

Thank you, fixed it in the meantime but it took me a while to understand. – cyruslk Nov 16 '20 at 17:20
You need to url encode it using `urllib.parse.quote("username@gmail.com")` and `urllib.parse.quote("p@ssword")`. Check this answer here https://stackoverflow.com/a/39283299/337666 – Shrikant Prabhu Dec 18 '20 at 06:46

score 4 · Answer 3 · answered Apr 06 '21 at 16:04

4

I faced the same problem I have changed the password but it didn't work. My Password includes numbers I removed them and it worked

answered Apr 06 '21 at 16:04

Daniya Niazi

113
1
7

score 1 · Answer 4 · answered Apr 04 '22 at 13:49

1

First, the error MongoServerError: bad auth: Authentication failed indicates username and password may be incorrect.

Solution: In credential.js remove the brackets <> around username and password then you have a database connection.

answered Apr 04 '22 at 13:49

Ken Mwangi

11
3

score 0 · Answer 5 · answered Jan 20 '21 at 16:14

0

Also try it as,

'CLIENT' : { 'host' : 'connection_string_to_mongodb' }

since, connection_string has username, password, database name, clustername and so, just have this one key-value pair in the client. It worked for me.

answered Jan 20 '21 at 16:14

mananbh9

421
4
3

score 0 · Answer 6 · answered Feb 01 '21 at 15:24

0

Also make sure your password does not have any numbers or special characters

answered Feb 01 '21 at 15:24

xi_darius

54
6

score 0 · Answer 7 · answered Mar 06 '21 at 12:32

0

Might as well try to add your IP to the white list. Go to Network Access -> Add IP Adress -> Current IP, then save changes and try again, hope it'll help.

answered Mar 06 '21 at 12:32

Slava.In

161
2
11

score 0 · Answer 8 · answered May 15 '21 at 23:41

0

making a new admin user account worked for me. i found this was not only case with pymongo but also when I was working with mongo shell.

answered May 15 '21 at 23:41

sailormoonbs

9
3

score 0 · Answer 9 · edited Sep 24 '21 at 13:57

0

For some reason when I avoid copy / paste and type in the username and password it works.

edited Sep 24 '21 at 13:57

Dharman

26,923
21
73
125

answered Sep 24 '21 at 13:51

Avi Bro

17
1
5

Muhammad Fayyaz · Answer 10 · 2021-10-04T09:46:33.867

0

the solution is to remove brackets <> from the user name and password. enter the correct database name. Give access to your database so that the data is posted into your database.

edited Oct 04 '21 at 09:46

answered Oct 04 '21 at 09:27

Muhammad Fayyaz

1
1

score 0 · Answer 11 · answered Oct 13 '21 at 18:35

0

The solution for this is make sure you username and password should include '_' between name and number if in case your name or password includes number

answered Oct 13 '21 at 18:35

Manthena Sriram

1

score 0 · Answer 12 · answered Jan 18 '22 at 18:28

Use this

const config = {
    mongoConnectionURL: "mongodb://cyruslk:MY_PASS_HERE@franklinford-shard-00-00-3dveb.mongodb.net:27017,franklinford-shard-00-01-3dveb.mongodb.net:27017,franklinford-shard-00-02-3dveb.mongodb.net:27017/test?ssl=true&replicaSet=FranklinFord-shard-0&authSource=admin&retryWrites=true&w=majority",
    mongoDatabaseName: "FranklinFord",
  }

NOTE:

remove '<' & '>' from the username and password and make sure that the username and password lies just before and after the colon (symbol = ":" ) there should be no empty space before and after the colon

score 0 · Answer 13 · answered Feb 19 '22 at 14:58

This is Not Always Only About The Password

Though your error already answered by some people which was a password issue. However, looking at the comments and answer here, I see a lot of people having similar error but unable to solve with the provided answer. But why ?

This error is not only about the password. Here Database Name, Password and Username do matter.
Since Database name, Password and Username are part of the url, therefore if you use any special character in any of these three part of your url, then you need to replace them with % and then ASCII Code of those special sign. For example: for $- sign you need to replace it with %36%45
And obviously remove < and > sign also from the initial link you copied which is like <password>.
See ASCII Code Here
See the image to understand more

score 0 · Answer 14 · answered May 06 '22 at 09:45

For me, I solved this by creating another admin user. I forgot that I have a deployed web app that is already using an admin user. So creating another admin user and use it as a Mongo URI on a different web app helped solve me this authentication issue

Arijit Das · Answer 15 · 2021-06-22T16:26:31.777

-1

I faced the same problem and found the solution. but changed the database password and it works. [try to keep the auto-generated password]

edited Jun 22 '21 at 16:26

answered Jun 10 '21 at 14:23

Arijit Das

1
2

you can change the password from the Database Access sections of MongoDB. and try to keep auto-generated password. – Arijit Das Jun 12 '21 at 02:53

score -2 · Answer 16 · answered May 14 '21 at 07:20

pip install djongo
pip install dnspython
DATABASES = {
    'default': {
        'ENGINE': 'djongo',
         "NAME": "database name",
        "CLIENT": {
        "host": "connection_string_to_mongodb",
        
    },
        
    }
}

the above code worked for me. separately providing username and password didn't work

Mongodb + Atlas: 'bad auth Authentication failed.', code: 8000,

16 Answers16

This is Not Always Only About The Password

Linked

Related