how can I check database connection to mysql in django

Question

how can I do it?

I thought, I can read something from database, but it looks too much, is there something like?:

settings.DATABASES['default'].check_connection() 

Answer 1

All you need to do is start a application and if its not connected it will fail. Other way you can try is on shell try following -

from django.db import connections from django.db.utils import OperationalError db_conn = connections['default'] try:     c = db_conn.cursor() except OperationalError:     connected = False else:     connected = True 

Answer 2

Run the shell

python manage.py shell 

Execute this script

import django print(django.db.connection.ensure_connection()) 

If it print None means everything is okay, otherwise it will throw an error if something wrong happens on your db connection