How to connect MongoDB Compass using MLab connection string

Question

I have database hosted on MLab and I am trying to connect it with Compass. I am using host and port given in connection string but it is showing error, here is my screenshot:

What am I doing wrong?

score 45 · Answer 1 · edited Dec 04 '19 at 13:22

45

Had same problem manage to solve it like this:

A. Go to your db in mlab and in the tab choose "users"

B. Create a new user ex: username: admin password: 123456

C: Go to compass and fill it this way

Example of your connection path

ds012345.mlab.com:56789/myDBname

hostname

ds012345.mlab.com

port

56789

authentication: username /password

admin // or the name of the user you created in step A
123456 // or password for the user you created in step A

authentication database

myDBname // the name of your database in mlab

edited Dec 04 '19 at 13:22

Tomas Vancoillie

3,463
2
29
45

answered Dec 29 '18 at 13:18

elad BA

1,760
11
17

5

For me, Authentication Database is the problem. – AutumnSky Apr 22 '19 at 13:21
9

The main thing was **Authentication Database**, that was admin by default. – Rohit Sharma May 17 '19 at 07:48
3

This should be set as correct answer! Solved my problem – Raphael Schubert Dec 10 '19 at 11:50
1

Solved! Still I don't understand why we need to create another database user. – fedeteka Feb 06 '20 at 18:45

score 12 · Answer 2 · answered Sep 22 '18 at 11:07

12

I just had the same problem.

I fixed it by updating my version of MongoDB Compass. No problems encountered with version 1.15.4.

Also, Authentication Database should not have the value "admin" but the name of the DB to connect you.

To make your connection easier, don't hesitate to copy your entire connection string into the clipboard. Compass detects it and proposes to automatically fill in the connection form.

answered Sep 22 '18 at 11:07

Philippe Matray

1,511
1
13
22

1

Yes,"Authentication Database" means "the database you want to connect to". – kol Jan 21 '19 at 17:40

score 10 · Answer 3 · answered Dec 17 '18 at 20:45

The problem that I had was the Authentication Database Compass filled in automatically wasn't correct for my setup. By default, this was pointing to admin but it needs to point to the database that the user is associated with.

Summed up: The database of admin didn't exist.

Just to rule it out, double check what database you're pointing to. It should be in the name, like ds739176/database_name where database_name is, you guessed it, the name of your database.

Hope this helps.

Yes, that was exactly the case for me too! – maesk Oct 08 '20 at 14:29 — maesk, Oct 08 '20 at 14:29

score 4 · Answer 4 · answered Sep 28 '18 at 21:39

The required credentials are not your login credentials to MLab, instead these are database user credentials.

How to get them:

click on your DB on MLab.
go to users tab and create new user.
use the created users credentials to access db.
set authenticationdatabase to be your database.

score 3 · Answer 5 · answered Oct 27 '18 at 04:13

I had the same problem. MongoDB url was working in code but Authentication failed was showing in MongoDB Compass.

When I checked, my mongodb password was iam%40me1234.

Here I'm using %40 HTML hex code in the password for @ character.

So, If we will use the original character in the password like iam@me1234 in MongoDB Compass then it will work great.

Here is a full list of Hex codes

score 0 · Answer 6 · answered Jun 13 '20 at 13:59

What I did:

Click on "Fill in connection fields individually" option in Compass.
Enter the hostname (Example ds051234.mlab.com)
Enter PORT (Example 12345)
Select Username/password in the Authentication option.
Enter username and password (Create a new user in mlab.com for your database)
Authentication Database (Just enter the "database name" in this field. Example: heroku_8967jgy5)

I hope this will help you.

How to connect MongoDB Compass using MLab connection string

6 Answers6

Example of your connection path

How to get them: