01/11/2025
Connect Django with MySQL steps: 1. python -m venv userappenv
2. cd userappenv
3. Scripts\activate
4. pip install Django
5. python -m django startproject userappnew
6. pip install pymysql
7.Edit your Django settings.py
a) import pymysql
pymysql.install_as_MySQLdb()
b). DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'your_database_name', # database from XAMPP phpMyAdmin
'USER': 'root', # XAMPP default user
'PASSWORD': '', # leave blank unless you set one
'HOST': '127.0.0.1', # or 'localhost'
'PORT': '3306', # XAMPP MySQL default port
}
}
8. python manage.py migrate
if you see error
pip uninstall django -y
pip install "django
