Pycharm 连接Mysql8

1.通过Pycharm 安装pymysql 

2.创建Python链接Mysql 文件,并查询数据库数据

import pymysql#连接mysql数据库
IP = "192.168.50.7"
Port= 3306
UserName ="root"
Password="*******"
DbName ="world"
conn = pymysql.connect(host=IP, user=UserName,password=Password,database=DbName,charset="utf8")
# 定义执行SQL语句对象
cursor = conn.cursor()
# 定义执行SQL语句
sql ="select * from  city;"# 执行SQL语句
cursor.execute(sql)
# 获取所有记录列表
results = cursor.fetchall()
#根据表字段定义变量
for row in results:ID = row[0]Name = row[1]CountryCode = row[2]District = row[3]Population = row[4]# 打印结果print("ID=%s,Name=%s,CountryCode=%s,District=%s,Population=%s" % \(ID, Name, CountryCode, District, Population))# 关闭光标对象
cursor.close()
# 关闭数据库连接
conn.close()