即使正确安装了pip和MySQL连接器，我也无法在Pycharm上连接到mysql。
即使正确安装了pip和MySQL连接器，我也无法在Pycharm上连接到mysql。
提问于 2018-12-13 07:11:44
我已经正确安装了mysql连接器，命令提示符甚至显示安装成功，但由于某种原因，Pycharm在安装连接器时显示错误。
编码器从这里开始
Collecting mysqlconnector
Using cached https://files.pythonhosted.org/packages/e4/7c/957e0c387d4c65df42ba56d5160456b0ff6f83f3cda122e18287605e3711/mysqlconnector-0.1.1.tar.gz
Installing collected packages: mysqlconnector
Running setup.py install for mysqlconnector: started
Running setup.py install for mysqlconnector: finished with status 'error'
Complete output from command "C:\Users\Farhan Hasnat\PycharmProjects\untitled1\venv\Scripts\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\FARHAN~1\\AppData\\Local\\Temp\\pycharm-packaging\\mysqlconnector\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\FARHAN~1\AppData\Local\Temp\pip-record-hnanue0h\install-record.txt --single-version-externally-managed --compile --install-headers "C:\Users\Farhan Hasnat\PycharmProjects\untitled1\venv\include\site\python3.7\mysqlconnector":
running install
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "C:\Users\FARHAN~1\AppData\Local\Temp\pycharm-packaging\mysqlconnector\setup.py", line 47, in <module>
'mysqlconnector = mysqlconnector.cli:cli',
File "C:\Users\Farhan Hasnat\AppData\Local\Programs\Python\Python37-32\lib\distutils\core.py", line 148, in setup
dist.run_commands()
File "C:\Users\Farhan Hasnat\AppData\Local\Programs\Python\Python37-32\lib\distutils\dist.py", line 966, in run_commands
self.run_command(cmd)
File "C:\Users\Farhan Hasnat\AppData\Local\Programs\Python\Python37-32\lib\distutils\dist.py", line 985, in run_command
cmd_obj.run()
File "C:\Users\FARHAN~1\AppData\Local\Temp\pycharm-packaging\mysqlconnector\setup.py", line 20, in run
raise Exception("You probably meant to install and run mysql-connector")
Exception: You probably meant to install and run mysql-connector
----------------------------------------
Command ""C:\Users\Farhan Hasnat\PycharmProjects\untitled1\venv\Scripts\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\FARHAN~1\\AppData\\Local\\Temp\\pycharm-packaging\\mysqlconnector\\setup.py';f=getattr**strong text**(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\FARHAN~1\AppData\Local\Temp\pip-record-hnanue0h\install-record.txt --single-version-externally-managed --compile --install-headers "C:\Users\Farhan Hasnat\PycharmProjects\untitled1\venv\include\site\python3.7\mysqlconnector"" failed with error code 1 in C:\Users\FARHAN~1\AppData\Local\Temp\pycharm-packaging\mysqlconnector\
You are using pip version 10.0.1, however version 18.1 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.回答 2
Stack Overflow用户
回答已采纳
发布于 2018-12-13 09:27:25
"msql-connector-repackaged“应该是"mysql-connector-repackaged"，还要尝试在"myDB”变量中传入一个数据库(数据库必须已经创建)：
mydb = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="name of your database"
)除此之外，你使用的是哪个版本的pycharm？据我所知，pycharm版不支持使用数据库管理系统，如Oracle，MySQL，SQL等，你需要专业版来做这件事。
我已经能够在pycharm中使用SQLite构建数据库，但这是python内置的。我不知道您处理的数据有多大，但如果它很小，您可以求助于SQLite。
https://www.jetbrains.com/help/pycharm/relational-databases.html
此外，您可以尝试其他连接包(注意: PyCharm的创建者IntelliJ可能最终会删除它们，以便保留非免费连接器版本的mysql兼容性)，例如:mysql- PyCharm、mysql-connector-python、mysql-connector-dd和mysql-connector-rf。
Stack Overflow用户
发布于 2020-06-11 22:13:56
您可能需要安装Python3和MySQL开发头和库，如下所示：
$sudo apt-get install python3-dev default-libmysqlclient-dev build-essential然后运行pip install：
$pip install mysqlclient现在，您可以在Pycharm上添加包mysqlclient
文档：https://github.com/PyMySQL/mysqlclient-python
:)
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/53752804
复制相关文章
相似问题
腾讯云开发者
