Python connect to MySQL error

Question

Why do I keep getting this error TypeError: __init__() takes 1 positional argument but 2 were given when I want to connect Python with MySQL?

The exact error code is:

Traceback (most recent call last):
  File "cone.py", line 4, in 
    conn = mysql.connector.connect(f)
  File "C:\Python34\lib\site-packages\mysql\connector\__init__.py", line 179, in connect
    return MySQLConnection(*args, **kwargs)
  File "C:\Python34\lib\site-packages\mysql\connector\connection.py", line 57, in __init__
    super(MySQLConnection, self).__init__(*args, **kwargs)
TypeError: __init__() takes 1 positional argument but 2 were given

Here's my code:

import mysql.connector

f="localhost","username","password","db"
conn = mysql.connector.connect(f)

c= conn.cursor()

c.execute("SELECT * FROM test")

rows=c.fetchall()

for eachRow in rows:
    print (eachRow)

Is there a stack trace? Telling you which line caused the problem? — khelwood
– khelwood, Commented Aug 17, 2017 at 12:49
What examples are you following to get the connector.connect(f) syntax? — OneCricketeer
– OneCricketeer, Commented Aug 17, 2017 at 12:51
@cricket_007 Well I just tried it with MySQLdb.connect but it said that ImportError: No module named 'MySQLdb' — reposter
– reposter, Commented Aug 17, 2017 at 12:53

MishaVacic · Accepted Answer · 2017-08-17 13:05:53Z

1

If you have managed to fix MySQLdb then you can connect like this

import MySQLdb

mydb = MySQLdb.connect(host = 'localhost',user = 'flo',passwd = '********',db = 'yourdb')
cur = mydb.cursor()
command = cur.execute('SELECT * FROM yourtable')
results = cur.fetchall()

print (results)

answered Aug 17, 2017 at 13:05

MishaVacic

1,9378 gold badges27 silver badges29 bronze badges

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

Comments

Mohideen bin Mohammed · Accepted Answer · 2017-08-17 13:20:16Z

1

in python3.4 try the same using pymysql,

to install pip3 install PyMySQL

import pymysql
conn = pymysql.connect("localhost","dev","pwd","db_name")
cur = conn.cursor()

should connect like this in mysql.connector.connect

conn = mysql.connector.connect(host="localhost",user="uname", password="mypwd", database="emp_db")

For example,

>>> conn = mysql.connector.connect(f)Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python2.7/dist-packages/mysql/connector/__init__.py", line 98, in connect
    return MySQLConnection(*args, **kwargs)
TypeError: __init__() takes exactly 1 argument (2 given)
>>> conn = mysql.connector.connect(host="localhost",user="uname", password="pwd", database="reposter$tutorial_database")
>>>

here is the Doc

edited Aug 17, 2017 at 13:20

answered Aug 17, 2017 at 12:55

Mohideen bin Mohammed

20.4k11 gold badges121 silver badges131 bronze badges

7 Comments

reposter Over a year ago

thx for the answer but i already tried it with conn = mysql.connector.connect(host="localhost",user="uname", password="mypwd", database="emp_db") than it said:TypeError: __init__() takes 1 positional argument but 5 were given

Mohideen bin Mohammed Over a year ago

what it says? >>> conn = mysql.connector.connect("localhost","dev","pwd","my_db") Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/lib/python2.7/dist-packages/mysql/connector/__init__.py", line 98, in connect return MySQLConnection(*args, **kwargs) TypeError: __init__() takes exactly 1 argument (5 given) >>>

Mohideen bin Mohammed Over a year ago

if you gave like this it will through an error.. otherwise it should work..

OneCricketeer Over a year ago

You're missing that the other error correctly says 5 positional arguments were given

Mohideen bin Mohammed Over a year ago

@cricket_007 you OP missing or me?

|

maina joseph · Accepted Answer · 2020-04-02 06:11:43Z

0

#import mysql connector
import mysql.connector

#declare your database variables
DBHOST = 'localhost'
DBNAME = 'database_name'
DBUSER = 'root'
DBPASS = ''

#establish the connection
connection = mysql.connector.connect(host=DBHOST, database=DBNAME, user=DBUSER, passwd=DBPASS)

answered Apr 2, 2020 at 6:11

maina joseph

1

Comments

reposter · Accepted Answer · 2017-08-17 14:22:11Z

-1

Try this:

conn = mysql.connector.connect(host="host", user="username",   password ="pwd", database="db")

edited Aug 17, 2017 at 14:22

reposter

331 gold badge1 silver badge7 bronze badges

answered Aug 17, 2017 at 12:55

Debanik Dawn

8198 silver badges31 bronze badges

3 Comments

reposter Over a year ago

yeah tried it but then it said TypeError: __init__() takes 1 positional argument but 5 were given but thx for the answer

Mohideen bin Mohammed Over a year ago

@Flo if you didnt provide arguments it will say like this.. so give assignment like user etc

Debanik Dawn Over a year ago

@Flo Did you give keyword arguments? You have to. Read this: dev.mysql.com/doc/connector-python/en/…

Collectives™ on Stack Overflow

Python connect to MySQL error

4 Answers 4

Comments

7 Comments

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

7 Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related