python MySQLdb error?

Question

while i am trying to connect with python MySQLdb, i get an 'Invalid Arguments' error.

import MySQLdb
conn = MySQLdb.connect (host = "localhost",user = "root",passwd = "",db = "test")

what is the reason for getting such a error?.

But, the following code with _mysql works fine.

db=_mysql.connect("localhost","root","","test")

Just a note - "localhost" is the default host for MySQLdb, so you don't need to specify it. — Amber
– Amber, Commented Jan 24, 2011 at 7:24

Tauquir · Accepted Answer · 2011-01-24 08:46:29Z

2

import MySQLdb.cursors

DATABASE= MySQLdb.connect(host='localhost', user='username', passwd='password', db='databasename', cursorclass=MySQLdb.cursors.DictCursor)

Hope it helps.

answered Jan 24, 2011 at 8:46

Tauquir

6,9437 gold badges39 silver badges48 bronze badges

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

Comments

Nanne · Accepted Answer · 2011-01-24 07:54:28Z

0

Shouldn't that be

conn = MySQLdb.connect ("localhost","root","","test")

?

(random reference: http://www.tutorialspoint.com/python/python_database_access.htm )

answered Jan 24, 2011 at 7:54

Nanne

64.4k16 gold badges122 silver badges166 bronze badges

Collectives™ on Stack Overflow

python MySQLdb error?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related