如何将xampp中的MYSql用于python 3？

Question

当我试图使用命令“MySQL”安装pip3客户端时，会出现以下错误。

Complete output from command python setup.py egg_info:
    /bin/sh: mysql_config: command not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/private/var/folders/l1/f1klm_s92g53c9v2p1vrdwg80000gn/T/pip-install-a0t6svmj/mysqlclient/setup.py", line 18, in <module>
        metadata, options = get_config()
      File "/private/var/folders/l1/f1klm_s92g53c9v2p1vrdwg80000gn/T/pip-install-a0t6svmj/mysqlclient/setup_posix.py", line 53, in get_config
        libs = mysql_config("libs_r")
      File "/private/var/folders/l1/f1klm_s92g53c9v2p1vrdwg80000gn/T/pip-install-a0t6svmj/mysqlclient/setup_posix.py", line 28, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    OSError: mysql_config not found

XAMPP版本：- 7.2.3.0 Python:- 3.7

有人能帮我解决这个错误吗？谢谢

Answer 1

要安装MySQL-python包，输入以下命令：

pip install MySQL-python

要安装mysql-连接器-python包，输入以下命令：

pip install mysql-connector-python

要安装pymysql包，输入以下命令：

pip install pymysql

代码样本

hostname = 'localhost'
username = 'USERNAME'
password = 'PASSWORD'
database = 'DBNAME'
def doQuery( conn ) :
cur = conn.cursor()

cur.execute( "SELECT fname, lname FROM employee" )
for firstname, lastname in cur.fetchall() :
    print firstname, lastname
print "Using MySQLdb…"
import MySQLdb
myConnection = MySQLdb.connect( host=hostname, user=username, passwd=password, db=database )
doQuery( myConnection )
myConnection.close()
print "Using pymysql…"
import pymysql
myConnection = pymysql.connect( host=hostname, user=username, passwd=password, db=database )
doQuery( myConnection )
myConnection.close()
print "Using mysql.connector…"
import mysql.connector
myConnection = mysql.connector.connect( host=hostname, user=username, passwd=password, db=database )
doQuery( myConnection )
myConnection.close()

Answer 2

确保至少尝试过这些命令的。

• pip install mysql
• export PATH=$PATH:/usr/local/mysql/bin
• pip install MySQL-Python
• 命令运行root或sudo。

如果什么都没有改变。这些解决方案之一可能有助于：

1. 尝试从bash运行which mysql_config。如果找不到，请运行：locate mysql_config。二进制文件路径需要在$PATH环境变量中，或者在setup.py中为缺少的模块指定。
2. 您可以尝试安装不同的软件包。有：mysql-connector-python或libmysqlclient-dev。python-dev可能会有所帮助。
3. 尝试查找目录和文件mysql/bin、mysql_config和MySQL-Python，并将其位置添加到$PATH中。

编辑:有几个解决方案可以尝试：

• apt-get install python-mysqldb
• Debian/Ubuntu：sudo apt-get install libmysqlclient-dev
• Debian/Ubuntu (2018年)：sudo apt install default-libmysqlclient-dev
• XAMPP (指定OP)：export PATH=$PATH:/Applications/XAMPP/xamppfiles/bin