[Django]-MySQL Connector/python not working in django

# for mysql connector use this

DATABASES = {
'default': {
    'ENGINE': 'mysql.connector.django',
    'NAME': 'dbname',               
    'USER': 'user',
    'PASSWORD': '',
    'HOST': '127.0.0.1',
    'PORT': '3306',
},

}

If you’re using Oracle’s connector, you need to use their Django db backend.

See their documentation.

Try: pip install mysql-python

If that does not work: make sure you can connect to your database (use phpmyadmin or mysql workbench to test that)

try this for MySQL Connector that working in django:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'djangolearn',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '3306',
    }
}

or try this for MySQL Connector pool that working in django:

DATABASES = {
    'default': {
        'ENGINE': 'PyMysqlPool.mysql.connector.django',
        'NAME': 'djangolearn',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'OPTIONS': {
            'autocommit': True,
            'pool': {
                #use = 0 no pool else use pool
                "use":0,
                # size is >=0,  0 is dynamic pool
                "size":10,
                #pool name
                "name":"local",
            }
        },
    }
}