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")
asked Jan 24, 2011 at 7:19
Sanal MS
2,5144 gold badges24 silver badges32 bronze badges
-
Just a note - "localhost" is the default host for MySQLdb, so you don't need to specify it.Amber– Amber2011年01月24日 07:24:37 +00:00Commented Jan 24, 2011 at 7:24
2 Answers 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
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 badges123 silver badges166 bronze badges
Comments
default