Why am I unable to connect to a mysql database using python and mysql.connector?

Question

I am trying to connect to a mysql database, but having issues. I am trying to use mysql connector (not sure if this is the most efficient library to use), but I am having an error.

Here is my basic script:

import mysql.connector

def test_sql_query():
    db = mysql.connector.connect(host='hostname', database='db', user='dbuser', password='dbpass' port=000)
    cur = db.cursor()
    if db.is_connected():
        print('Connected to MySQL database')
    try:
        sql_command = "select * from test where test like '%FileUploadAgent%' and status='00' order by test desc;"
        cur.execute(sql_command)
        db.commit()
        rows = cur.fetchall()
        for row in rows:
            print "   ", row[1][1]
    except:
        print "did not work"
    db.close()

Error:

 File "sql_test.py", line 44, in <module>
    test_sql_query()
  File "sql_test.py", line 6, in sterling_agent_sql_query
    db = mysql.connector.connect("host='hostname.com' database='dbname' user='dbuser' password='dbpassword' port='000'")
  File "/Library/Python/2.7/site-packages/mysql/connector/__init__.py", line 179, in connect
    return MySQLConnection(*args, **kwargs)
  File "/Library/Python/2.7/site-packages/mysql/connector/connection.py", line 57, in __init__
    super(MySQLConnection, self).__init__(*args, **kwargs)
TypeError: __init__() takes exactly 1 argument (2 given)

I am assuming that I am doing the connection wrong.

Posting this with the assumption that it's a code problem and not bad credentials. — Ben
– Ben, Commented Jun 3, 2016 at 19:44

Andy · Accepted Answer · 2016-06-03 19:48:22Z

1

The parameter you are passing to .connect() is wrong. You are passing a string. Instead, each of those should be their own parameter.

db = mysql.connector.connect(host='hostname', 
    database='db', 
    user='dbuser', 
    password='dbpass', 
    port=000)

Additionally, port needs to be an integer, not a string. I also assume that the 000 you have is example data. If not, that's not valid.

answered Jun 3, 2016 at 19:48

Andy♦

50.8k62 gold badges181 silver badges240 bronze badges

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

Comments

Jeffrey Naujok · Accepted Answer · 2016-06-03 19:50:09Z

0

You have the format of the connect incorrect, putting all of the variables inside of quotes makes the method treat it as a single, string input to the method.

db = mysql.connector.connect("host='hostname' database='db' user='dbuser' password='dbpass' port='000'")

should be

db = mysql.connector.connect(
    host='hostname',
    database='db',
    user='dbuser',
    password='dbpass',
    port=0)

Note that your port value also should be a valid port (not the echo port) for the database.

edited Jun 3, 2016 at 19:50

answered Jun 3, 2016 at 19:48

Jeffrey Naujok

13 bronze badges

2 Comments

Andy Over a year ago

You are missing commas between your parameters, and port needs to be an integer, not a string.

Ben Over a year ago

It still won't connect.

Roman Skydan · Accepted Answer · 2018-11-30 13:43:36Z

0

I got the same problem my solution was to uninstall MySQL connector.

python -m pip uninstall mysql-connector

And then reinstall it using:

python -m pip install mysql-connector

and it works for me.

edited Nov 30, 2018 at 13:43

Roman Skydan

5,7664 gold badges22 silver badges40 bronze badges

answered Nov 30, 2018 at 13:02

Kassian

112 bronze badges

Collectives™ on Stack Overflow

Why am I unable to connect to a mysql database using python and mysql.connector?

3 Answers 3

Comments

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Related