Client Does Not Support Authentication Protocol Requested By Server Consider Upgrading Mysql Client

I want to run python manage.py syncdb to build a database with Django. However, I get the following error: client does not support authentication protocol requested by server cons

Solution 1:

Django doesn't automatically generate your database. You must create it first before syncing or migrating. Also, you need to install MySQLDB package on your python package list. But if you're using Python3 then I suggest you use PyMySQL then add these on your settings.py

import pymysql

pymysql.install_as_MySQLdb()

Solution 2:

I had a similar issue, I fixed this by replacing import MySQLdb with

import pymysql
pymysql.install_as_MySQLdb()

in settings.py.

I am using MySQLdb version 1.2.5, PyMySQ version 0.9.2, Python 2.7 and Django 1.11.2.