TypeError：_init_()接受1个位置参数，但给出了5个

Question

这是我要在其中建立数据库连接的Python代码。但是我在我的代码中得到了一个类型错误。请告诉我是什么问题。

import pymysql

connnection = pymysql.connect("localhost", "root", "", "dbname")

错误：

Traceback(most recent call last):

 File "c:/Users/Dell/Desktop/Full Code/COllectUrls.py", line 21, in <module>

   connnection = pymysql.connect("localhost", "root", "", "dbname")

TypeError: _ init _() takes 1 positional argument but 5 were given

Answer 1

试试这个

import pymysql

# Connect to the database
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='passwd',
                             database='db',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

Answer 2

这将适用于3.x版本

import pymysql

connection = pymysql.connect(host='localhost',user='root',password='',database='db_emp',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)


cursor = connection.cursor()
cursor.execute("SELECT VERSION()")
data = cursor.fetchone()
print ("Database version : %s " % data)

Answer 3

试试这个：

import pymysql

con = pymysql.connect(host='localhost',
        user='user7',
        password='s$cret',
        db='testdb',
        charset='utf8mb4')