python - 如何将来自 xampp 的 MYSql 用于 python 3?
问题描述
当我尝试使用命令“pip3 install mysqlclient”安装 MySQL 客户端时出现以下错误。
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
谁能帮我解决这个错误?谢谢
解决方案
要安装 MySQL-python 包,请键入以下命令:
pip install MySQL-python
要安装 mysql-connector-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()
推荐阅读
- laravel - 选择具有关系 laravel 一对多的查询
- javascript - 结帐表未在前端正确呈现
- mips - 了解 MIPS while 循环
- java - 将 Java 转换为 Kotlin 时,com.android.dex.DexIndexOverflowException: method ID not in [0, 0xffff]: 65536 in android studio
- javascript - 如何根据值对对象进行排序?
- django - 我在开发过程中进行了模型迁移。现在生产数据库无法检测到更改
- javascript - 当用户选择 False Hit 单选按钮时,如果文本字段为空,如何确保无法提交表单?
- winforms - 虚拟云端硬盘更改我的文件名以在其名称末尾添加 (1)
- java - 如何记录 Spring WebClient 的线程池指标?
- django - 单击 django-tables2 中的行将我带到另一个表?