Use MySQL with Django

Introduction

Here, we will explain the settings for using MySQL as the django database instead of the standard sqlite. In addition, it is assumed that MySQL is installed by MAMP.

Declaration of database to use

First, in manage.py, specify that you will use MySQL as follows.

`manage.py`


import pymysql


pymysql.install_as_MySQLdb()

Description of database information to use

Then write the detailed information of the database in settings.py.

`settings.py`


DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME':Database name,
        'USER':Username (of your database),
        'PASSWORD':Password (of your database),
        'HOST': '/Applications/MAMP/tmp/mysql/mysql.sock',
        'PORT': '8889'  #For MAMP,
    }
}

Recommended Posts

Use MySQL with Django

Use Unicode 6.0 emoji with django / MySQL

Use Gentelella with django

Use LESS with Django

Use prefetch_related conveniently with Django

Internationalization with django

CRUD with Django

Django + MySQL settings

Authenticate Google with Django

Django 1.11 started with Python3.6

Upload files with Django

Development digest with Django

Use RTX 3090 with PyTorch

Use ansible with cygwin

Use pipdeptree with virtualenv

Output PDF with Django

[Python] Use JSON with Python

Use Mock with pytest

Markdown output with Django

Twitter OAuth with Django

Use MySQL from Python

Use tensorboard with Chainer

Use DynamoDB with Python

Use pip with MSYS2

Getting Started with Django 1

Use Python 3.8 with Anaconda

Use pyright with Spacemacs

File upload with django

Use python with docker

Use MySQL from Python

Azure External Storage MySQL Challenges with Django (PTVS)

Pooling mechanize with Django

Use Enums with SQLAlchemy

Use Python / Django with Windows Azure Cloud Service!

Use tensorboard with NNabla

Use GPS with Edison

Start today with Django

Getting Started with Django 2

Use nim with Jupyter

Do Django with CodeStar (Python3.6.8, Django2.2.9)

Use Trello API with python

Use shared memory with shared libraries

Use "$ in" operator with mongo-go-driver

Use directional graphs with networkx

Get started with Django! ~ Tutorial ⑤ ~

Use TensorFlow with Intellij IDEA

Minimal website environment with django

Create an API with Django

Use Twitter API with Python

Use pip with Jupyter Notebook

Do Django with CodeStar (Python3.8, Django2.1.15)

Deploy Django serverless with Lambda

Python3 + Django ~ Mac ~ with Apache

Use DATE_FORMAT with SQLAlchemy filter

Use TUN / TAP with Python

Getting Started with Python Django (1)

Django Getting Started: 4_MySQL Integration

Use sqlite3 with NAO (Pepper)

Use MySQL from Anaconda (python)

Create a homepage with django

Use sqlite load_extensions with Pyramid