blocks|key|2628910|text|mysqlclient官方支持python3.7，你可以在这里找到：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2628911|https://pypi.python.org/pypi/mysqlclient|2628912|1)你可以下载，PyMySQL+0.9.2|2628913|2)解压并复制pymysql文件夹到python+Lib文件夹|2628914|3)对于连接，您可以这样做(创建一个文件，例如freeman.py)：|2628915|#!/usr/bin/env+python

import+pymysql

conn+=+pymysql.connect(host='localhost',+port=3306,+user='root',+passwd='',+db='freemanDB')

cur+=+conn.cursor()
cur.execute("SELECT+*+FROM+users")

print(cur.description)
print()

for+row+in+cur:
++++print(row)

cur.close()
conn.close()|code-block|syntax|javascript|2628916|entityMap|0|LINK|mutability|MUTABLE|url|1|https://pypi.python.org/pypi/PyMySQL^0|0|B|F|9|0|0|14|0|0|8|D|1|0|7|7|P|3|0|N|A|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|16|8|@]|D|@$9|17|A|18|1|19]]|E|$]]|$1|H|3|I|5|6|7|1A|8|@]|D|@$9|1B|A|1C|1|1D]]|E|$]]|$1|J|3|K|5|6|7|1E|8|@$9|1F|A|1G|B|C]|$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|1J|8|@$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|N|3|O|5|P|7|1M|8|@]|D|@]|E|$Q|R]]|$1|S|3|-4|5|6|7|1N|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|G]]|Z|$5|V|W|X|E|$Y|10]]]]

<code>mysqlclient</code> supports <code>python3.7</code> officially, you can find it here : 

<a href="https://pypi.python.org/pypi/mysqlclient" rel="noreferrer">https://pypi.python.org/pypi/mysqlclient</a>

1)you can download , <a href="https://pypi.python.org/pypi/PyMySQL" rel="noreferrer">PyMySQL 0.9.2</a> 
2)extract &amp; copy the folder <code>pymysql</code> into the python <code>Lib</code> folder 
3)and for connection you can do like this(make a file for example <code>freeman.py</code>):

<pre><code>#!/usr/bin/env python

import pymysql

conn = pymysql.connect(host='localhost', port=3306, user='root', passwd='', db='freemanDB')

cur = conn.cursor()
cur.execute("SELECT * FROM users")

print(cur.description)
print()

for row in cur:
 print(row)

cur.close()
conn.close()
</code></pre>

blocks|key|2628949|text|有两种方法可以安装MySQL连接器。第二种方法是首选的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2628950|1.+MySQL+Installer|offset|length|2628951|这是Oracle的产品安装程序。问题是它已经过时了。它只知道Python+3.6版，没有更新的版本。要安装较新版本的Python，请使用选项2。|2628952|2.+Python包管理器，pip|style|CODE|2628953|Python包管理器随Python一起提供，称为pip。它从Python库下载软件包，并根据您安装它所使用的PyPI版本(或virtual+copy)将其安装到一个自动位置。您需要的包是mysql-connector-python。事实上，官方documentation表示，这是安装MySQL连接器的推荐方法。|2628954|例如，在Windows上，通过在“开始”菜单中搜索打开命令提示符(cmd.exe)。导航到pip的安装目录。或者确保pip的目录包含在$PATH变量中(您可以通过在开始菜单中搜索"PATH“来编辑该变量)。|2628955|命令提示符将显示以下内容：|2628956|PS+C:\Users\Ryan>+|code-block|syntax|javascript|2628957|除了代替我的用户名，它将显示您的用户名，或您找到pip后导航到的路径，如"C:\blah\blah“。然后使用这个命令...|2628958|输入：|2628959|pip+install+mysql-connector-python|2628960|它会下载并安装它。|2628961|结果：|2628962|PS+C:\Users\Ryan>+pip+install+mysql-connector-python
Collecting+mysql-connector-python
Downloading+https://files.pythonhosted.org/packages/2d/65/3fc902c0f7635912800c6b935313b99b9d4426419ef7ba04f76231b24923/mysql_connector_python-8.0.12-py2.py3-none-any.whl+(300kB)
++++100%25+%7C████████████████████████████████%7C+307kB+1.1MB/s
Collecting+protobuf>=3.0.0+(from+mysql-connector-python)
Downloading+https://files.pythonhosted.org/packages/77/78/a7f1ce761e2c738e209857175cd4f90a8562d1bde32868a8cd5290d58926/protobuf-3.6.1-py2.py3-none-any.whl+(390kB)
++++100%25+%7C████████████████████████████████%7C+399kB+1.8MB/s
Requirement+already+satisfied:+setuptools+in+c:\users\ryan\appdata\local\programs\python\python37\lib\site-packages+(from+protobuf>=3.0.0->mysql-connector-python)+(40.4.3)
Collecting+six>=1.9+(from+protobuf>=3.0.0->mysql-connector-python)
Using+cached+https://files.pythonhosted.org/packages/67/4b/141a581104b1f6397bfa78ac9d43d8ad29a7ca43ea90a2d863fe3056e86a/six-1.11.0-py2.py3-none-any.whl
Installing+collected+packages:+six,+protobuf,+mysql-connector-python
Successfully+installed+mysql-connector-python-8.0.12+protobuf-3.6.1+six-1.11.0|2628963|然后，您可以通过显示您已安装的所有包(不包括随Python提供的标准库)来确保它已安装：|2628964|2628965|PS+C:\Users\Ryan>+pip+list|2628966|2628967|Package++++++++++++++++Version
----------------------+-------
mysql-connector-python+8.0.12
pip++++++++++++++++++++18.0
protobuf+++++++++++++++3.6.1
setuptools+++++++++++++40.4.3
six++++++++++++++++++++1.11.0|2628968|要检查是否已将其安装到正确的Python版本，请使用pip+-V。要确保已将其安装到正确的副本(虚拟或原始)，请查看安装该软件包的文件路径：|2628969|PS+C:\Users\Ryan>+pip+-V|2628970|2628971|pip+18.0+from+c:\users\ryan\appdata\local\programs\python\python37\lib\site-packages\pip+(python+3.7)|2628972|例如，在我的系统中，它在文件夹路径中显示python37，所以它将其安装到我原来的Python3.7.0安装，而不是旧版本或虚拟环境(conda或virtualenv等)。|2628973|使用Python可执行文件而不是pip检查版本|2628974|PS+C:\Users\Ryan>+py+-V
Python+3.7.0|2628975|如果需要将其安装到比默认安装更早或更新的Python版本，请插入版本号作为选项(也称为“开关”)，使用-。例如，要选择版本3.6：|2628976|py+-3.6+-m+pip+install+mysql-connector-python|2628977|-可以在Windows和类Unix操作系统上运行。|2628978|entityMap|0|LINK|mutability|MUTABLE|url|https://www.mysql.com/downloads/|1|https://www.w3schools.com/python/python_pip.asp|2|https://pypi.org/|3|https://realpython.com/python-virtual-environments-a-primer/|4|https://dev.mysql.com/doc/dev/connector-python/8.0/installation.html^0|0|3|F|0|0|0|E|3|0|O|3|2L|M|O|3|1|1I|4|2|1Q|C|3|3E|D|4|0|X|7|19|3|1M|3|0|0|0|O|3|0|0|0|0|0|0|0|0|0|0|0|Q|6|0|0|0|0|K|8|1V|5|21|A|0|G|3|0|0|1F|1|0|0|0|1|0^^$0|@$1|2|3|4|5|6|7|2F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|2G|8|@]|9|@$D|2H|E|2I|1|2J]]|A|$]]|$1|F|3|G|5|6|7|2K|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|2L|8|@$D|2M|E|2N|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|2O|8|@$D|2P|E|2Q|J|K]|$D|2R|E|2S|J|K]]|9|@$D|2T|E|2U|1|2V]|$D|2W|E|2X|1|2Y]|$D|2Z|E|30|1|31]|$D|32|E|33|1|34]]|A|$]]|$1|N|3|O|5|6|7|35|8|@$D|36|E|37|J|K]|$D|38|E|39|J|K]|$D|3A|E|3B|J|K]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|3C|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|3D|8|@]|9|@]|A|$U|V]]|$1|W|3|X|5|6|7|3E|8|@$D|3F|E|3G|J|K]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|3H|8|@]|9|@]|A|$]]|$1|10|3|11|5|T|7|3I|8|@]|9|@]|A|$U|V]]|$1|12|3|13|5|6|7|3J|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|3K|8|@]|9|@]|A|$]]|$1|16|3|17|5|T|7|3L|8|@]|9|@]|A|$U|V]]|$1|18|3|19|5|6|7|3M|8|@]|9|@]|A|$]]|$1|1A|3|Z|5|6|7|3N|8|@]|9|@]|A|$]]|$1|1B|3|1C|5|T|7|3O|8|@]|9|@]|A|$U|V]]|$1|1D|3|15|5|6|7|3P|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|T|7|3Q|8|@]|9|@]|A|$U|V]]|$1|1G|3|1H|5|6|7|3R|8|@$D|3S|E|3T|J|K]]|9|@]|A|$]]|$1|1I|3|1J|5|T|7|3U|8|@]|9|@]|A|$U|V]]|$1|1K|3|15|5|6|7|3V|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|T|7|3W|8|@]|9|@]|A|$U|V]]|$1|1N|3|1O|5|6|7|3X|8|@$D|3Y|E|3Z|J|K]|$D|40|E|41|J|K]|$D|42|E|43|J|K]]|9|@]|A|$]]|$1|1P|3|1Q|5|6|7|44|8|@$D|45|E|46|J|K]]|9|@]|A|$]]|$1|1R|3|1S|5|T|7|47|8|@]|9|@]|A|$U|V]]|$1|1T|3|1U|5|6|7|48|8|@$D|49|E|4A|J|K]]|9|@]|A|$]]|$1|1V|3|1W|5|T|7|4B|8|@]|9|@]|A|$U|V]]|$1|1X|3|1Y|5|6|7|4C|8|@$D|4D|E|4E|J|K]]|9|@]|A|$]]|$1|1Z|3|-4|5|6|7|4F|8|@]|9|@]|A|$]]]|20|$21|$5|22|23|24|A|$25|26]]|27|$5|22|23|24|A|$25|28]]|29|$5|22|23|24|A|$25|2A]]|2B|$5|22|23|24|A|$25|2C]]|2D|$5|22|23|24|A|$25|2E]]]]

There are two ways to install MySQL connector. The second way is preferred.

<h2>1. <a href="https://www.mysql.com/downloads/" rel="noreferrer">MySQL Installer</a></h2>

This is Oracle's product installer. The problem is that it is outdated. It is only aware of Python version 3.6, and nothing newer. To install for a newer version of Python, use option 2.

<h2>2. Python package manager, <code>pip</code></h2>

The Python package manager comes with Python, called <a href="https://www.w3schools.com/python/python_pip.asp" rel="noreferrer"><code>pip</code></a>. It downloads the package from the <a href="https://pypi.org/" rel="noreferrer">PyPI</a> repository and installs it in an automatic location based on what version of Python (or what <a href="https://realpython.com/python-virtual-environments-a-primer/" rel="noreferrer">virtual copy</a>) you use to install it. The package that you want is <code>mysql-connector-python</code>. In fact, the official <a href="https://dev.mysql.com/doc/dev/connector-python/8.0/installation.html" rel="noreferrer">documentation</a> says this is the recommended method for installing the MySQL Connector.

For example, on Windows, open up the Command Prompt (<code>cmd.exe</code>) by searching in the Start Menu. Navigate to the directory where <code>pip</code> is installed. Or make sure that <code>pip</code>'s directory is included in the $PATH variable (which you can edit by searching for "PATH" in the Start Menu).

The command prompt will show you this:

<pre><code>PS C:\Users\Ryan&gt; 
</code></pre>

except instead of my username, it'll show your username, or the path you navigated to after you found <code>pip</code>, like "C:\blah\blah". Then use this command...

Input:

<pre><code>pip install mysql-connector-python
</code></pre>

It downloads and installs it.

Results:

<pre><code>PS C:\Users\Ryan&gt; pip install mysql-connector-python
Collecting mysql-connector-python
Downloading https://files.pythonhosted.org/packages/2d/65/3fc902c0f7635912800c6b935313b99b9d4426419ef7ba04f76231b24923/mysql_connector_python-8.0.12-py2.py3-none-any.whl (300kB)
 100% |████████████████████████████████| 307kB 1.1MB/s
Collecting protobuf&gt;=3.0.0 (from mysql-connector-python)
Downloading https://files.pythonhosted.org/packages/77/78/a7f1ce761e2c738e209857175cd4f90a8562d1bde32868a8cd5290d58926/protobuf-3.6.1-py2.py3-none-any.whl (390kB)
 100% |████████████████████████████████| 399kB 1.8MB/s
Requirement already satisfied: setuptools in c:\users\ryan\appdata\local\programs\python\python37\lib\site-packages (from protobuf&gt;=3.0.0-&gt;mysql-connector-python) (40.4.3)
Collecting six&gt;=1.9 (from protobuf&gt;=3.0.0-&gt;mysql-connector-python)
Using cached https://files.pythonhosted.org/packages/67/4b/141a581104b1f6397bfa78ac9d43d8ad29a7ca43ea90a2d863fe3056e86a/six-1.11.0-py2.py3-none-any.whl
Installing collected packages: six, protobuf, mysql-connector-python
Successfully installed mysql-connector-python-8.0.12 protobuf-3.6.1 six-1.11.0
</code></pre>

Afterward, you can make sure it is installed by displaying all packages that have been installed by you (not including standard libraries, which come with Python):

Input:

<pre><code>PS C:\Users\Ryan&gt; pip list
</code></pre>

Results:

<pre><code>Package Version
---------------------- -------
mysql-connector-python 8.0.12
pip 18.0
protobuf 3.6.1
setuptools 40.4.3
six 1.11.0
</code></pre>

To check if you installed it to the right version of Python, use <code>pip -V</code>. To make sure you installed it to the right copy (virtual or original), look at the file path where the package was installed:

<pre><code>PS C:\Users\Ryan&gt; pip -V
</code></pre>

Results:

<pre><code>pip 18.0 from c:\users\ryan\appdata\local\programs\python\python37\lib\site-packages\pip (python 3.7)
</code></pre>

For example, in my system, it shows <code>python37</code> in the folder path, so it installed it to the original Python 3.7.0 installation I have, instead of an older version or virtual environment (<code>conda</code> or <code>virtualenv</code>, etc).

To check the version using the Python executable, instead of <code>pip</code>:

<pre><code>PS C:\Users\Ryan&gt; py -V
Python 3.7.0
</code></pre>

If you need to install it to an older or newer Python version than the default installation, insert the version number as an option (aka. "switch") in the command, using <code>-</code>. For example, to select version 3.6:

<pre><code>py -3.6 -m pip install mysql-connector-python
</code></pre>

The <code>-</code> works on both Windows and Unix-like OSs.

blocks|key|2418524|text|pip+install+mysql-connector-python|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2418525|cmd上的这个命令可以解决这个问题。如果在任何情况下遇到问题，请以管理员身份运行cmd。|unstyled|2418526|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>pip install mysql-connector-python
</code></pre>

This command on cmd will solve the problem. Run cmd as administrator if in any case you face problem.

blocks|key|2418552|text|要使用MySQL，必须安装flask_mysqldb包|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2418553|pip+install+flask_mysqldb|code-block|syntax|javascript|2418554|要使用它：|2418555|from+project+import+app

from+flask_mysqldb+import+MySQL|2418556|配置MySQL：|2418557|app.config['MYSQL_HOST']+=+'localhost'

app.config['MYSQL_USER']+=+'root'

app.config['MYSQL_PASSWORD']+=+'yourpassword'

app.config['MYSQL_DB']+=+'mydbfile'

app.config['MYSQL_CURSORCLASS']+=+'MyCursor'|2418558|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You must install flask_mysqldb package in order to use MySQL

<pre><code>pip install flask_mysqldb
</code></pre>

To use it:

<pre><code>from project import app

from flask_mysqldb import MySQL
</code></pre>

Config MySQL:

<pre><code>app.config['MYSQL_HOST'] = 'localhost'

app.config['MYSQL_USER'] = 'root'

app.config['MYSQL_PASSWORD'] = 'yourpassword'

app.config['MYSQL_DB'] = 'mydbfile'

app.config['MYSQL_CURSORCLASS'] = 'MyCursor'
</code></pre>

I am in the need of saving data into a MySQL database, my problem is I can't find the package...

Solution explored:

<ul>
<li>Oracle website: <a href="https://dev.mysql.com/downloads/connector/python/" rel="noreferrer">https://dev.mysql.com/downloads/connector/python/</a></li>
<li>Trying to install MySQLdb from Pycharm it said non existing.</li>
</ul>

So if anyone has an alternative to it for python 3.7, or knows how to get the connector for version 3.7 I would be happy.

MySQL package for python 3.7

包管理器

SQL数据库

数据库

Windows

Python

MySQL

Unix

我需要将数据保存到MySQL数据库中，我的问题是我找不到包…探索的解决方案：甲骨文网站：Trying to install MySQLdb from PyCharm.oracle表示不存在。所以，如果有人有Python3.7的替代品，或者知道如何获得3.7版的连接器，我会很高兴。

问Python3.7的MySQL包
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Python3.7的MySQL包EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Python3.7的MySQL包
EN