id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
31491	"dbshell command for MySQL backend uses ""passwd"" instead of ""password""."	Maruti N Sharma	Maruti N Sharma	"For MySql, ""passwd"" has been replaced with ""password"" long time ago, please check here [https://code.djangoproject.com/ticket/5024]
But dbshell command still looks for ""passwd"" key in the  settings for db password, resulting in connection error.
This behaviour is also slightly different than other back-ends.

Pull request submitted: [https://github.com/django/django/pull/12763]\\
\\
\\


**Steps to reproduce:**

- create a new django project, set env
- choose mysql as db back-end
- specify db setting as following (ref: [https://docs.djangoproject.com/en/3.0/ref/settings/#std:setting-DATABASES]) 

{{{
# use actual db username, password etc
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mydatabase',
        'USER': 'mydatabaseuser',
        'PASSWORD': 'mypassword',
        'HOST': '127.0.0.1',
        'PORT': '5432',
    }
}
}}}

- Open a terminal and activate respective environment
- run:  ''python manage.py dbshell''
- You should get following error: **Access denied for user 'mydatabaseuser'@'localhost' (using password: NO)**

(My apologies for any mistake, I am new to bug-tracking system)

"	Cleanup/optimization	assigned	Core (Management commands)	master	Normal		dbshell, db, command-line		Accepted	1	0	0	0	1	0