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 44 · Answer 1 · answered Feb 07 '21 at 21:09

44

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,938
2
12
22

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 43 · Accepted Answer · edited Nov 15 '20 at 21:11

43

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

12,582
6
26
49

answered Nov 15 '20 at 16:08

Nikhil Thorat

446
6
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 8 · Answer 3 · answered Apr 06 '21 at 16:04

8

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

180
3
10

score 1 · Answer 4 · 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 1 · Answer 5 · 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 1 · Answer 6 · answered Jul 29 '22 at 20:50

1

After lots of headache searching for the answer, I realize that my in the connection stream still had the <> around the password. Make sure to remove this.

answered Jul 29 '22 at 20:50

JavaEddie

31
1

score 1 · Answer 7 · answered Oct 30 '22 at 07:36

1

I also facing the same issue and I removed +srv and it worked for me.

answered Oct 30 '22 at 07:36

Suyash

29
7

score 0 · Answer 8 · 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

541
4
3

score 0 · Answer 9 · 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

104
9

score 0 · Answer 10 · 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

597
1
9
22

score 0 · Answer 11 · 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
5

Muhammad Fayyaz · Answer 12 · 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 13 · 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 14 · 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 15 · 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

score 0 · Answer 16 · answered Jun 16 '22 at 08:20

If you are using dotenv then first make sure you have installed it and called it from index.js page require('dotenv').config();

Then the most uncommon mistake might be Creating a variable named "USERNAME" in the .env file.

//Do not create a variable named USERNAME=abc in the .env file

score 0 · Answer 17 · edited Jun 17 '22 at 16:02

0

Use ${password} instead of <password> in code

edited Jun 17 '22 at 16:02

Tyler2P

2,324
26
22
31

answered Jun 16 '22 at 20:39

mia

1

1

Your answer could be improved by providing an example of the solution and how it helps the OP. – Tyler2P Jun 17 '22 at 16:02

score 0 · Answer 18 · edited Aug 27 '22 at 20:48

0

Have tried all listed solutions and nothing worked except for "Removing numbers from password" from database cluster. And it worked.

edited Aug 27 '22 at 20:48

ant_dev

653
8
16

answered Aug 22 '22 at 10:53

Abdulahad Pasha

1
1

score 0 · Answer 19 · answered Nov 09 '22 at 15:44

check your username and password of your database created NOT from you network.

like this

           username    password                                 name of ur database

mongodb+srv://eshop1235:benonti1244$$@cluster0.4nzfbwx.mongodb.net/eshop-database?retryWrites=true&w=majority

all of these answer u will find in:

right navigation:

security

 quickstart

 database access

 network access

the ooptions edit.

enter image description here

before doing it, please check whether ur databased is "active".

enter image description here

score 0 · Answer 20 · answered Nov 22 '22 at 23:54

0

I had the same issue and what worked for me was changing my user's name, from yazi-kun to yazikun I believe that your username should not contain space or any special character

answered Nov 22 '22 at 23:54

Yazi-Kun

1

Yes, as you said if user name or password contains special characters then you need to replace them with their ascii code after % sign. For example $ would be %36. – Temuujin Dev Nov 25 '22 at 18:14

score 0 · Answer 21 · answered Dec 16 '22 at 23:49

0

I had the same issue. I created a new cluster, and the problem is solved.

answered Dec 16 '22 at 23:49

shashant

1

score 0 · Answer 22 · answered Jan 02 '23 at 21:12

0

The allowed special characters was where I was going wrong. If you enter your password in the connection URL exactly how you entered it in your account and include some of the characters contained here, it will not work.

answered Jan 02 '23 at 21:12

cfynes

63
4

score 0 · Answer 23 · answered Jan 26 '23 at 20:33

In my case I was putting the DB_URL inside the doten (.env file), and by mistake I put the DB_URL like this:

DB_URL = "mongodb+srv://USERNAME:<password>@cluster0.8v3jxwm.mongodb.net/?retryWrites=true&w=majority"

And this is a mistake, we do not must add a string quotation here, it must be like this:

DB_URL = mongodb+srv://USERNAME:<password>@cluster0.8v3jxwm.mongodb.net/?retryWrites=true&w=majority

score 0 · Answer 24 · answered Jun 17 '23 at 10:36

Double check that your IP is 'whitelisted' on your MongoDB Atlas "Network Access" settings, or use the 'access from anywhere' option, which is: 0.0.0.0/0 (includes your current IP address).
I don't know if this will help anyone: for me, I was starting my server via: node app.js
I did npm start instead (my package.json reads: "start": "node server/app.js") and my connection went through.
Perhaps running the server without npm, the .env file was not being recognized, I honestly have no idea but it worked.

Arijit Das · Answer 25 · 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

mrb · Answer 26 · 2023-05-22T11:24:15.493

-1

I solved the same issue on my web app by following the percent encoding (sometimes called URL enconding), which is a way to encode characters that have specific meaning in this type of context. The encoding consists of substitution of the special characters; for example: A '%' followed by the hexadecimal representation of the ASCII value of the replace character, as explained here.

plain-text part is: ! you need to encode it as: %21

edited May 22 '23 at 11:24

answered May 18 '23 at 14:49

mrb

39
8

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - [From Review](/review/late-answers/34409631) – esqew May 21 '23 at 22:13

score -1 · Answer 27 · answered Jul 01 '23 at 04:27

I tried everything in this thread and other threads including changing my password, adding another user, trying another collection, and could not figure this out after wasting hours. Very frustrating - I ended up switching to CouchDB because at least I could do this very basic thing with no issues.

score -2 · Answer 28 · 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,

28 Answers28

This is Not Always Only About The Password

Linked

Related