1 #! usr/bin/python 2 #coding=utf-8 3  4 # Python + 连接器 构成一个客户端 5 from pymysql import connect 6  7 # 连接选项 8 db_config = { 9     'host': '192.168.1.105',10     'port': 3306,11     'user': 'wendy',12     'passwd': '1234567890',13     'db': 'testDB2',14     'charset': 'utf8',15 }16 17 # 连接到数据库18 connection = connect(**db_config)19 20 try:21     with connection.cursor() as cursor:22         sql = "SELECT * FROM `testDB2`.`users`"23         cursor.execute(sql)24         for i in cursor:25             print(i)26 finally:27     connection.close()

参考网站：