python+MySQL架构

 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()