Opened 9 months ago
Closed 9 months ago
#35228 closed Uncategorized (invalid)
django.db.utils.OperationalError: (1044, "Access denied for user 'xyz'@'localhost' to database 'product'")
| Reported by: | Amit Malaker | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 5.0 |
| Severity: | Normal | Keywords: | mysql, db, connection |
| Cc: | Amit Malaker | Triage Stage: | Unreviewed |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
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
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/