python连接mysql数据库并读取数据的实现

1、安装pymysql包 pip install pymysql 注： MySQLdb只支持python2，pymysql支持python3 2、连接数据 import pymysql import pandas as pd from pandas import DataFrame as df conn = pymysql.Connect( host = 'IP地址', port = 端口号, user = '用户名', passwd = '用户密码', db = '数据库名称', charset = 'utf8' ) 注： 查看本机IP地址：cmd输