Opened 8 years ago
Closed 8 years ago
#29309 closed Cleanup/optimization (needsinfo)
Recommended MySQL Setup Does Not Work Properly
| Reported by: | ReStartercc | Owned by: | nobody |
|---|---|---|---|
| Component: | Documentation | Version: | 2.0 |
| Severity: | Normal | Keywords: | Database Setup |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Python 3.6.1
Django 2.0
Mac OS 10.13.3
Following the instruction given in https://docs.djangoproject.com/en/2.0/ref/databases/#mysql-notes, installed pymysql with pip and then modified the settings.py to set up the adaptor according to https://dev.mysql.com/doc/connector-python/en/connector-python-django-backend.html, the url given by the official document.
Then when executing python3 manage.py makemigrations error appears which displays ImportError: No module named 'MySQLdb. It is likely that django still uses MySQLdb, which is not supported by python3, as default in the release.
The fix that works for me would be adding following code in the __init__.py of the site to use pymysql to replace mysqldb.
import pymysql pymysql.install_as_MySQLdb()
Change History (2)
comment:1 by , 8 years ago
comment:2 by , 8 years ago
| Easy pickings: | unset |
|---|---|
| Resolution: | → needsinfo |
| Status: | new → closed |
Please give a complete traceback of the ImportError. I don't see any
MySQLdbimports outside ofdjango.db.backends.mysqlso am not sure how this could happen if your settings points to the'mysql.connector.django'engine.