How to connect to Mongo database locally using python

Question

I am using ipython 2.7. I am creating database name enron in mongodb. I have tried to connect to this database locally but the following error occurred - how do I fix it?

this my code:

import json
import pymongo  # pip install pymongo
from bson import json_util 
from pymongo import MongoClient# Comes with pymongo
conn = pymongo.Connection('mongodb://user:[email protected]:33499/enron')
client = MongoClient()

error:

ConnectionFailure: could not connect to localhost:27017: [Errno 10061] No connection     could be made because the target machine actively refused it

Amit · Accepted Answer · 2017-04-20 13:47:55Z

21

Below are commands to create connection and query

from pymongo import MongoClient
client = MongoClient('hostname', 27017)
db = client.database_name
collection = db.collection_name
collection.find_one({"name":"name1"})

answered Apr 20, 2017 at 13:47

Amit

4705 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raja Jawahar · Accepted Answer · 2019-02-16 09:52:04Z

6

from pymongo import MongoClient
from bson import json_util


MONGODB_HOST = 'localhost'
MONGODB_PORT = 27017
DB_NAME = 'Your DB name'
COLLECTION_NAME = 'collectionname'

@app.route("/")
def getDatas():
    connection = MongoClient(MONGODB_HOST, MONGODB_PORT)
    collection = connection[DB_NAME][COLLECTION_NAME]
    projects = collection.find()
    json_projects = []
    for project in projects:
        json_projects.append(project)
    json_projects = json.dumps(json_projects, default=json_util.default)
    connection.close()
    return json_projects

if __name__ == "__main__":
    app.run(host='0.0.0.0',port=5000,debug=True)

answered Feb 16, 2019 at 9:52

Raja Jawahar

7,0029 gold badges48 silver badges57 bronze badges

Comments

Suhas_Pote · Accepted Answer · 2022-08-02 08:43:57Z

3

Solution worked for me

#!pip install pymysql

import pymysql

pymysql.install_as_MySQLdb()

import MySQLdb

#!pip install pymongo
import pymongo
import json
from pymongo import MongoClient


import pandas as pd
from pymongo import MongoClient
# if __name__ == '__main__':
#     client = MongoClient("localhost", 27017, maxPoolSize=50)
client = MongoClient("localhost", 27017, maxPoolSize=50)
db = client.mydb
collection = db.angel
data = pd.DataFrame(list(collection.find()))

data

'''
Address City    Name    State   ZIP _id
0   123 Main St Whereverville   Jane Doe    CA  90210   5af03bfa8ca570abf4a2f76c
1   555 Broadway Ave    New York    John Doe    NY  10010   5af03bfa8ca570abf4a2f76d
'''

edited Aug 2, 2022 at 8:43

answered Jun 19, 2019 at 15:49

Suhas_Pote

4,7202 gold badges28 silver badges41 bronze badges

Comments

guy_fawkes · Accepted Answer · 2014-03-03 06:06:50Z

2

Refer this PyMongo Connection to connect and Connection is deprecated

answered Mar 3, 2014 at 6:06

guy_fawkes

9658 silver badges31 bronze badges

1 Comment

Rafe Over a year ago

link is outdated

jatinkumar patel · Accepted Answer · 2015-01-07 09:01:10Z

0

Run this command from command line in mongo installtion directory.

...>mongo>...>bin>

mongod --dbpath data/db (here data/db is a path where your database)

answered Jan 7, 2015 at 9:01

jatinkumar patel

3,00023 silver badges28 bronze badges

Comments

DRAD · Accepted Answer · 2019-08-25 13:03:01Z

0

A derivation of @amit above, I use this to quickly test a mongodb connection:

# pip install pymongo
from pymongo import MongoClient
client = MongoClient('mongodb://user:password@host:port/database')

for db in client.list_databases():
    print(db)

answered Aug 25, 2019 at 13:03

DRAD

1574 bronze badges

1 Comment

Apurva Kunkulol Over a year ago

Where to find the "user" and "password" parameters for a localhost installation?

Collectives™ on Stack Overflow

How to connect to Mongo database locally using python

6 Answers 6

Comments

Comments

Solution worked for me

Comments

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Solution worked for me

Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related