[Django]-How to make Django work with unsupported MySQL drivers such as gevent-mysql or Concurrence's MySQL driver?

by

37👍

✅

three cheers for @traviscline’s suggestion to go with pymysql. his suggestion was based on this post from mozilla. all it takes is a simple patch to your manage.py file

#!/usr/bin/env python
+try:
+    import pymysql
+    pymysql.install_as_MySQLdb()
+except ImportError:
+    pass

changing the import in your settings file, and monkeypatch() since pymysql is a pure python driver.

travis mentioned that he tests for compatability by changing the imports and running the unittests for pymysql, mysqldb, and myconnpy.

note that there are already examples of finer details to watch out for – but overall this is an elegant, maintainable solution. i will update when i get this running in production!

👤egbutter

-1👍

I was successful in getting pymysql to work with Django doing the following :

  1. Comment out the try-except block at the beginning of the base.py file, where MySQLdb is imported.

  2. Add the following four lines to base.py

    try:
    import pymysql as Database
except ImportError:
    pass

  3. As mentioned in the link that egbutter posted, go to the base.py file and find-replace MySQLdb with pymysql at relevant portions of the file, i.e. don’t bother changing the error messages (you could, but that’s up to you).

  4. Save base.py, and run the following command from the apt location to see the server start up.

    python manage.py runserver
👤user2305491

Leave a comment