
django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")
The error message you're encountering, "django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")
", indicates that there is a problem with the database credentials you have provided in your Django settings. The error message is saying that the user 'root' with host 'localhost' is being denied access to the database because a password has not been provided.
To resolve this issue, you will need to provide the correct database credentials in your Django settings.
myapp\settings.py
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'databasename',
'HOST': '127.0.0.1',
'PORT': '3306',
'USER': 'root',
'PASSWORD': 'password',
}
}
In the above code, the database engine used is MySQL, and the database is given the name 'databasename'. The host address of the database is specified as '127.0.0.1' and the port number is specified as '3306'. The user accessing the database is given the username 'root' and the password for the database user (root) is 'password'.
In Django, the default database host is 'localhost' or 227.0.0.1 and the default database port is '5432' for PostgreSQL, '3306' for MySQL, and '27017' for MongoDB.
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Python
- How can you use SQL queries on pydroid app?
- Python for loop syntax
- Error "Running Scripts Is Disabled On This System"
- Hello World Python Code Example
- Create Superuser django
- Delete superuser in django
- How to remove whitespace from a string in Python
- How to pass default parameter value in Python function