[Django] #35228: django.db.utils.OperationalError: (1044, "Access denied for user 'xyz'@'localhost' to database 'product'")

[Django]

#35228: django.db.utils.OperationalError: (1044, "Access denied for user
'xyz'@'localhost' to database 'product'")
-------------------------------------+-------------------------------------
Reporter: amit-asl | Owner: nobody
Type: | Status: new
Uncategorized |
Component: Database | Version: 5.0
layer (models, ORM) | Keywords: mysql, db,
Severity: Normal | connection
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
It's been a while since I am having issues with integrating django with
mysql. Right Now, I am using django 3.1 and mysql 5.7. The issue, as you
can see, the django mysql client cannot connect to the server with the
given credential. Note for you, I have created the user with the name and
password and checked locally with the mysql cli client **mysql -u xyz -p**
. There it worked fine. I have manually created the user and provided all
grant privileges as well.

One important thing that I want to add that I came to test it locally when
I got issues with the docker compose first. I think the problem arises
from the internal django mysql client. Another follow up question is to
you that if it is possible to change django mysql client.

Waiting for your response
Thank you
--
Ticket URL: <https://code.djangoproject.com/ticket/35228>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#35228: django.db.utils.OperationalError: (1044, "Access denied for user
'xyz'@'localhost' to database 'product'")
-------------------------------------+-------------------------------------

Reporter: Amit Malaker | Owner: nobody
Type: Uncategorized | Status: closed
Component: Database layer | Version: 5.0
(models, ORM) |
Severity: Normal | Resolution: invalid
Keywords: mysql, db, | Triage Stage:
connection | Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by David Sanders):

* resolution: => invalid
* status: new => closed

Comment:

Hi,

The issue tracker is not a place to seek help with using Django – for that
you'll need to go to the forum or Discord where a friendly member of the
community will assist you: https://www.djangoproject.com/community/
--
Ticket URL: <https://code.djangoproject.com/ticket/35228#comment:1>