django.db.utils.OperationalError: (1045, u"Access denied for user 'my_user'@'localhost' (using password: NO)")

Question

I am trying to connect to MySQL from DJango. My settings.py file:

DATABASES = {
          'default':{
             'ENGINE': 'django.db.backends.mysql',
             'Name': 'my_db',
             'User': 'my_user',
             'Password': 'my_pass',
             'Host': 'localhost',
             'Port': '3306'
          }
}

}

I am getting following error.

django.db.utils.OperationalError: (1045, u"Access denied for user 'my_user'@'localhost' (using password: NO)")

I have tried following steps to solve the problem.

I have created the user:

    create user 'my_user'@'localhost' identified by 'my_pass';

And granted access as follows:

    grant all on *.* to 'my_user'@'localhost';
    flush privileges;

But, even though my problem not yet fixed. Can someone help me?

Thanks.

Maybe duplicated of https://stackoverflow.com/questions/11170133/using-mysql-with-django-access-denied-for-user-localhost/11170252 — Henrique Andrade, Jul 21 '18 at 03:42
I have posted the question after trying out the solution. I have granted the access to the user. But, even though I am getting the same error. — Shankar Muthu samy, Jul 21 '18 at 03:47
@ShankarMuthusamy Are you able to access mysql shell using above credentials using mysql client? — Ritesh Agrawal, Jul 21 '18 at 05:52
@RiteshAgrawal, yes I could able to access mysql shell using the credentials. — Shankar Muthu samy, Jul 23 '18 at 15:42
Possible duplicate of [Setting Django up to use MySQL](https://stackoverflow.com/questions/19189813/setting-django-up-to-use-mysql) — Rakmo, Jun 02 '19 at 10:05

score 0 · Answer 1 · answered Jul 23 '18 at 16:33

All the database config variables need to be caps but you have provided in title case.

DATABASES = {
      'default':{
         'ENGINE': 'django.db.backends.mysql',
         'NAME': 'my_db',
         'USER': 'my_user',
         'PASSWORD': 'my_pass',
         'HOST': 'localhost',
         'PORT': '3306'
      }
}

django.db.utils.OperationalError: (1045, u"Access denied for user 'my_user'@'localhost' (using password: NO)")

1 Answers1