python连接mysql，游标cursor和pandas访问，Jupyter环境

python连接MySQL

一、通过 mysql-connector 连接

安装 pip install mysql-connector-python

import mysql.connector
cnx = mysql.connector.connect(
    user='root', password='',
    host='127.0.0.1', database='mysql')

1. 用cursor使用sql语句

cursor = cnx.cursor()  # 实例化
cursor.execute('select user, host from user') # sql语句
result = cursor.fetchall() # 查询结果
print(result)
cnx