django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)") code example
Example 1: django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
You need to make changes in project settings.py.
Provide USER and PASSWORD for your database
If your database isn't mysql change ENGINE
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'myproject',
'USER': 'root',
'PASSWORD': 'rootpassword',
'HOST': 'localhost',
'PORT': '',
}
}
Example 2: django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
Example 3: django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
create user 'django'@'localhost' identified by 'django-user-password';
grant usage on *.* to 'django'@'localhost';
grant all privileges on django-database-1.* to 'django'@'localhost';