Python3循环通过DBs阵列连接

Question

我试图循环遍历具有相同连接信息的多个mysql主机，并对每个主机执行相同的查询&获取结果。

我仍然在学习python &我被困在以下几个方面；

import pymysql

ENDPOINTS=['endpoint01', 'endpoint02', 'endpoint03', 'endpoint04']
USER="SOME_USER"
PASS="SOME_PASSWORD"

print("Testing")

for x in ENDPOINTS:
  # Open database connection
  DATAB = pymysql.connect(x,USER,PASS)
  cursor = DATAB.cursor()
  cursor.execute("show databases like 'THIS%'")
  data = cursor.fetchall()
  print (data)
  DATAB.close()

这就是我所收到的错误；

DATAB = pymysql.connect(x,USER,PASS)
TypeError: __init__() takes 1 positional argument but 4 were given

Answer 1

你传递的参数不正确。试试DATAB = pymysql.connect(host=x,user=USER,password=PASS)