Setting Django up to use MySQL

MySQL support is simple to add. In your DATABASES dictionary, you will have an entry like this:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql', 
        'NAME': 'DB_NAME',
        'USER': 'DB_USER',
        'PASSWORD': 'DB_PASSWORD',
        'HOST': 'localhost',   # Or an IP Address that your DB is hosted on
        'PORT': '3306',
    }
}

You also have the option of utilizing MySQL option files, as of Django 1.7. You can accomplish this by setting your DATABASES array like so:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'OPTIONS': {
            'read_default_file': '/path/to/my.cnf',
        },
    }
}

You also need to create the /path/to/my.cnf file with similar settings from above

[client]
database = DB_NAME
host = localhost
user = DB_USER
password = DB_PASSWORD
default-character-set = utf8

With this new method of connecting in Django 1.7, it is important to know the order connections are established:

1. OPTIONS.
2. NAME, USER, PASSWORD, HOST, PORT
3. MySQL option files.

In other words, if you set the name of the database in OPTIONS, this will take precedence over NAME, which would override anything in a MySQL option file.

If you are just testing your application on your local machine, you can use

python manage.py runserver

Adding the ip:port argument allows machines other than your own to access your development application. Once you are ready to deploy your application, I recommend taking a look at the chapter on Deploying Django on the djangobook

Mysql default character set is often not utf-8, therefore make sure to create your database using this sql:

CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_bin

If you are using Oracle’s MySQL connector your ENGINE line should look like this:

'ENGINE': 'mysql.connector.django',

Note that you will first need to install mysql on your OS.

brew install mysql (MacOS)

Also, the mysql client package has changed for python 3 (MySQL-Client works only for python 2)

pip3 install mysqlclient

Related Posts:

  1. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  2. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  3. What is the easiest way to clear a database from the CLI with manage.py in Django?
  4. Error loading MySQLdb module: No module named ‘MySQLdb’
  5. Where does pip install its packages?
  6. Where does pip install its packages?
  7. django: TypeError: ‘tuple’ object is not callable
  8. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  9. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  10. No module named ‘psycopg2’
  11. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  12. No module named MySQLdb
  13. No module named MySQLdb
  14. How to check Django version
  15. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  16. is not JSON serializable
  17. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  18. Install mysql-python (Windows)
  19. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  20. No module named pkg_resources
  21. Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
  22. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  23. django import error – No module named core.management
  24. Forbidden (403) CSRF verification failed. Request aborted. Even using the {% csrf_token %}
  25. Python: tuple indices must be integers, not str when selecting from mysql table
  26. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  27. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  28. OSError – Errno 13 Permission denied
  29. Pylint “unresolved import” error in Visual Studio Code
  30. Django – no such table exception
  31. django MultiValueDictKeyError error, how do I deal with it
  32. Django – no such table exception
  33. ImportError: No module named MySQLdb
  34. Is there a list of Pytz Timezones?
  35. Django – “no module named django.core.management”
  36. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  37. NumPy array is not JSON serializable
  38. You are trying to add a non-nullable field ‘new_field’ to userprofile without a default
  39. pip install -r requirements.txt [Errno 2] No such file or directory: ‘requirements.txt’
  40. super(type, obj): obj must be an instance or subtype of type
  41. Django Rest Framework — no module named rest_framework
  42. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  43. Python Django: You’re using the staticfiles app without having set the STATIC_ROOT setting
  44. sqlite3.OperationalError: unable to open database file
  45. TypeError: int() argument must be a string, a bytes-like object or a number, not ‘list’
  46. Django reverse lookup of foreign keys
  47. ImportError: No module named ‘django.core.urlresolvers’
  48. ImportError: No module named mysql.connector using Python2
  49. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip
  50. How to set environment variables in PyCharm?
  51. ImportError: No module named ‘MySQL’
  52. H14 error in heroku – “no web processes running”
  53. What does this Django regular expression mean? `?P`
  54. OperationalError: database is locked
  55. Is it better to use path() or url() in urls.py for django 2.0?
  56. What is a “slug” in Django?
  57. TemplateDoesNotExist at /
  58. No module named django but it is installed
  59. What does on_delete do on Django models?
  60. Check if an object exists
  61. Find object in list that has attribute equal to some value (that meets any condition)
  62. How to check if a user is logged in (how to properly use user.is_authenticated)?
  63. The view didn’t return an HttpResponse object. It returned None instead
  64. CSV new-line character seen in unquoted field error
  65. gunicorn.errors.HaltServer: django
  66. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  67. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  68. How to query as GROUP BY in django?
  69. What is related_name used for?
  70. TypeError: ManyRelatedManager object is not iterable
  71. What is the most efficient way to store a list in the Django models?
  72. Line is too long. Django PEP8
  73. __init__() got an unexpected keyword argument ‘user’
  74. TypeError: unhashable type: ‘dict’
  75. ‘Conda’ is not recognized as internal or external command
  76. Python list of dictionaries search
  77. Extract file name from path, no matter what the os/path format
  78. Is arr.__len__() the preferred way to get the length of an array in Python?
  79. Running Python from Atom
  80. Converting Dictionary to List?
  81. pip3: command not found
  82. How to get keyboard input in pygame?
  83. How to use sys.exit() in Python
  84. ‘pip install’ fails for every package (“Could not find a version that satisfies the requirement”) [duplicate]
  85. ImportError: No module named ‘yaml’
  86. TypeError: ‘_io.TextIOWrapper’ object is not subscriptable
  87. What does “hashable” mean in Pytho
  88. Python multiprocessing.Pool: AttributeError
  89. Convert string to ASCII value python
  90. What does {0} mean in this Python string?
  91. Tab Error in Python
  92. Installation of pygame with Anaconda
  93. Is there a Python equivalent of the C# null-coalescing operator?
  94. Python 3.6 import requests
  95. Tensorflow 2.0 – AttributeError: module ‘tensorflow’ has no attribute ‘Session’
  96. Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
  97. How do I read image data from a URL in Python?
  98. Python: Convert timedelta to int in a dataframe
  99. Can’t concat bytes to str
  100. Unable to install boto3

Leave a Comment