python链接mysql数据库

# 1.导入pymysql包,如果没有安装pymysql包可以ctrl+r输入cmd打开dos窗口，输入pip install PyMySQL进行安装

import pymysql as pm

#2.定义好链接信息:链接IP，用户名，要连接的数据库，链接密码，编码
url = 'localhost'
user = 'root' 
db = 'pytest'
password = 'p123456'
charset ='utf8mb4'

#3.链接数据库
connectiont = pm.connect(host = url,user=user,passwd = password,db=db,charset = charset)

#4.创建游标
cursor = connectiont.cursor()

#5.定义sql语句
sql = 'show databases;'

#6.执行语句
cursor.execute(sql)

#7.取出结果集
cursor.fetchall()