python3 驅動 PyMySQL

標籤：mysql資料庫   oca   ldb   htm   connect   host   import   extern   串連   

 

Python版本： 3.5.0

MySqlDB官網只支援Python3.4，  使用第三方庫PyMysql串連Mysql資料庫。

https://pypi.python.org/pypi/PyMySQL#downloads  

　　import pymysql

# change root password to yours:
conn = pymysql.connect(host=‘localhost‘, port=3306,user=‘root‘,passwd=‘123456‘,db=‘world‘,charset=‘UTF8‘)
cursor = conn.cursor()



=================================================================================
python 3.4以下使用mysql 提供驅動 
http://dev.mysql.com/downloads/connector/python/2.0.html

# install mysql-connector-python:
# pip3 install mysql-connector-python --allow-external mysql-connector-python

 

IMPORT mysql.connector

# change root password to yours:
conn = mysql.connector.connect(USER=‘root‘, PASSWORD=‘password‘, DATABASE=‘test‘)

python3 驅動 PyMySQL