1 安装插件
安装MySQL-python出错:
Collecting MySQL-python
Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
ERROR: Complete output from command python setup.py egg_info:
ERROR: Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/private/var/folders/c2/sdkt0kk15r5dbbpt28jq_5k80000gn/T/pip-install-yyt4q0h8/MySQL-python/setup.py", line 13, in <module>
from setup_posix import get_config
File "/private/var/folders/c2/sdkt0kk15r5dbbpt28jq_5k80000gn/T/pip-install-yyt4q0h8/MySQL-python/setup_posix.py", line 2, in <module>
from ConfigParser import SafeConfigParser
ModuleNotFoundError: No module named 'ConfigParser'
----------------------------------------
ERROR: Command "python setup.py egg_info" failed with error code 1 in /private/var/folders/c2/sdkt0kk15r5dbbpt28jq_5k80000gn/T/pip-install-yyt4q0h8/MySQL-python/
原因python不支持,安装替代
pip install mysql-connector
Collecting mysql-connector
Downloading https://files.pythonhosted.org/packages/28/04/e40098f3730e75bbe36a338926f566ea803550a34fb50535499f4fc4787a/mysql-connector-2.2.9.tar.gz (11.9MB)
|████████████████████████████████| 11.9MB 69kB/s
Building wheels for collected packages: mysql-connector
Building wheel for mysql-connector (setup.py) ... done
Stored in directory: /Users/dotch/Library/Caches/pip/wheels/8c/83/a1/f8b6d4bb1bd6208bbde1608bbfa7557504bed9eaf2ecf8c175
Successfully built mysql-connector
Installing collected packages: mysql-connector
Successfully installed mysql-connector-2.2.9
2 示例
db = mysql.connector.connect(host='localhost', port=3306, user='root', passwd='xxx', db='xxx')
cursor = db.cursor()