CODEWITHSUNDEEP
pythonmysqlmysql-connector-python
pbft
pbft

Reputation: 41

Why does mysql.connector.connect fail with internal error?

I'm upgrading a database application from Python 2.7 to 3.4. I originally used mysqldb, but I'm trying to switch to mysql-connector. My database connection fails with an internal TypeError. Here's the code and the error:

import mysql.connector

try:
  dbh = mysql.connector.connect("localhost","pyuser","pypwd","jukebox")
except mysql.connector.Error as err:
  print("Failed opening database: {}".format(err))
  exit(1)

and here's the error:

# python loadcd.py
Traceback (most recent call last):
  File "loadcd.py", line 12, in <module>
    dbh = mysql.connector.connect("127.0.0.1","pyuser","pypwd","jukebox")
  File "/usr/local/lib/python3.4/dist-packages/mysql/connector/__init__.py", line 179, in connect
    return MySQLConnection(*args, **kwargs)
  File "/usr/local/lib/python3.4/dist-packages/mysql/connector/connection.py", line 57, in __init__
    super(MySQLConnection, self).__init__(*args, **kwargs)
TypeError: __init__() takes 1 positional argument but 5 were given

I'm at a loss. The exact same connection works with mysqldb, and I can connect with the same credentials using PHP or at the command line.

Upvotes: 0

Views: 722

Answers (2)

Aniket Singh
Aniket Singh

Reputation: 11

Use this and replace the values as per your configuration:

import mysql.connector

mydb = mysql.connector.connect(host="localhost",
                               user="yourusername",
                               password="yourpassword")

print(mydb)

Upvotes: 1

GProst
GProst

Reputation: 10227

You should provide keyword arguments:

dbh = mysql.connector.connect(host="localhost",user="pyuser",password="pypwd",database="jukebox")

Upvotes: 1

Related Questions