MAC下配置mysql-python 遇见的问题

Question

MBP上安装了XMAPP 准备再装一个mysql-python 搭建python web开发环境，下载了mysql-python文件，网上搜了各种方法，修改了文件，然后键入 sudo python setup.py install 后，python里面键入import MySQLdb 出现以下问题：

Answer 1

mysql-python 是需要本地安装了mysql才行。你安装的xmapp里面的mysql， mysql-python可能没找到正确的配置。

如果不是生产环境，使用 mysql-connector 替代，这个是 mysql官方推荐的驱动，纯python实现。不需要本地配置本地mysql。使用方法和 mysqldb一样。

Answer 2

mysql-python只是python语言使用mysql的一个模块。
在使用mysql-python的前提下，你必须先安装mysql for mac版。

Answer 3

Best way to connect to MySQL from python is to Use MySQL Connector/Python because it is official Oracle driver for MySQL for working with Python and it works with both Python 3 and Python 2.

• Download and Install MySQL Connector Python from here
• Connect to MySQL from Python using this module

Example:

import mysql.connector
 from mysql.connector import Error
 try:
     conn = mysql.connector.connect(host='hostname',
                         database='db',
                         user='root',
                         password='passcode')
     if conn.is_connected():
       cursor = conn.cursor()
       cursor.execute("select database();")
       record = cursor.fetchall()
       print ("Your connected to - ", record)
 except Error as e :
    print ("Print your error msg", e)
 finally:
    #closing database connection.
    if(conn.is_connected()):
       cursor.close()
       conn.close()