Python Django connection with MySQL
You just need to follow the steps
Create a database in cPanel, create a user for database, and give all permissions to the user.
Step 1:
Replace your existing Database in Settings.py in your project:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'your_database_name',
'USER': 'your_database_user',
'PASSWORD': 'your_database_password',
'HOST': '127.0.0.1',
'PORT': '3306',
'OPTIONS': {'charset': 'utf8mb4'},
}
}
*Replace the your_database_name, your_database_user, your_database_password with your own database credentials,
Step 2:
Now in your project folder
Goto __init__.py
Add Following lines to : __init__.py
import pymysql pymysql.install_as_MySQLdb()
Step 3:
Now Goto your Terminal in and activate your Python environment in cPanel.
Run the following command in the Terminal
pip install pymysql
Congratulations, you have successfully configured the database settings.
Now run the following commands in your terminal and you are ready to go
python manage.py makemigrations
python manage.py migrate
0 Comments