How to connect MYSQL using python

Question

I am using Python 2.7, MySQl 5.5, mysqldb(driver) and trying to connect to the mysql db using Python.

What I have tried

import MySQLdb
db = MySQLdb.connect(host="localhost",
                     user="root", # username
                      passwd="xxxxx", #  password
                      db="TEST") # name of the data base

Even tried 127.0.0.1 as local host

#ERROR
Traceback (most recent call last):
  File "C:/Python27/connect.py", line 6, in <module>
    db="prakash") # name of the data base
  File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
  OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

I am new to python, please help how to proceed?

Comments

import _mysql
db=_mysql.connect(host="localhost",user="joebob",
                  passwd="moonpie",db="thangs")

And let me know if problem still persists...

---

check this (http://thingsilearned.com/2009/05/03/simple-mysqldb-example/ read complete code) should be helpful

Answer 1

import MySQLdb

db = MySQLdb.connect(host="localhost",
user="root",
passwd="xxxxx",
db="xxxx",
port=int(3307))

// Got the answer

Comments

I hope the http://thingsilearned.com/2009/05/03/simple-mysqldb-example/ helped...

---

Since by default mySQL takes port number 3306 so generally there is no need to assign the port number....But during installation i assigned the port number as 3307..