unable to proceed further due to the error of 'update mysql client'

Question

enter image description here

Can someone please explain what exactly is this error and what should i do? Because i have tried updating mysql on my laptop to get rid of the error but it still says the same

updated mysql, still no change

Answer 1

Try to install the minimum required version of mysqlclient or newer

pip install mysqlclient==1.4.3

OR

pip install mysqlclient

MySQL and mysqlclient are different MySql is the database itself and mysqlclient is the client used to access the database

---

EDIT: Create a Virtual Environment to isolate your project required dependencies

1 Install virtual Environment to isolate your project To create a virtual env:

1. Create a new directory to stock your virtual environment :

c:\my_virtual_env

2. create the virtual env:

cd C:\my_virtual_env "C:\my_virtual_env" py -m venv database_project_venv"

2 Activate the virtual environment

C:\my_virtual_env\database_project_venv\Scripts\activate

You should have something like that displayed in your terminal :

(database_project_venv) c:\my_virtual_env

To deactivate the virtual environment use the command deactivate. For example: (database_project_venv) c:\database_project_11>> deactivate

3 Install Django

Still in your virtual environment, install Django:

1. Upgrade pip : `(database_project_venv) c:\database_project_1> python -m pip install --upgrade pip`

2. Install Django: `(database_project_venv) c:\database_project_1> pip install django`

3. Check django Version : `(database_project_venv) c:\database_project_1> django-admin --version`

4 Create your Django project

(database_project_venv) c:\> cd C:\database_project_1 
(database_project_venv) c:\database_project_1> django-admin startproject database_project 

You should have something like this

c:\database_project_1\database_project\

5 Create you app

(database_project_venv) c:\database_project_1> cd database_project
(database_project_venv) c:\database_project_1\database_project> python manage.py startapp my_app

Configure your settings.py by adding your app to the in INSTALLED_APPS

INSTALLED_APPS = [
…
    'my_app.apps.MyAppConfig',
…
]

6 Configure your MySql

In settings.py, configure your database

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',
    }
}

7 Database initialization

(database_project_venv) c:\database_project_1\database_project> python manage.py makemigrations
(database_project_venv) c:\database_project_1\database_project> python manage.py migrate

8 Create SuperUser (database_project_venv) c:\database_project_1\database_project> python manage.py createsuperuser

Update your project as needed

Now install your mysqlclient

(database_project_venv) c:\database_project_1\database_project> pip install mysqlclient

Try to run your project

(database_project_venv) c:\database_project_1\database_project> python manage.py runserver

Tell if everything works correctly now