Pycharm连接Mysql数据库

import pandas as pd
import pymysql
from sqlalchemy import create_engine

#创建一个Mysql连接器,用户名为root，密码123456
#地址为127.0.0.1，数据库名称为localhost，编码为UTF-8

# engine = create_engine('mysql+pymysql://root:123456@127.0.0.1:3306/localhost?charset=utf8')
# print(engine)

conn = pymysql.connect(host='localhost',port=3306,user='root',password='123456',db='softmodel')

formlist = pd.read_sql_query('show tables',con = conn)
print('localhost数据库数据表清单为:\n',formlist)
# sql = 'select * from 单词'
# data = pd.read_sql(sql=sql,con=conn)
# print(data)