[Answer]-Django, MySQL, syncdb: Access Denied to valid user

1👍

I did leave something out that I didn’t think was relevant, but is totally relevant.

This application has multiple databases defined. Syncdb only runs on one database at a time, and by default will run using the default database, as noted here:
https://docs.djangoproject.com/en/1.6/topics/db/multi-db/#synchronizing-your-databases

However, when my user didn’t have permission on the other database syncdb would fail. It didn’t indicate which database it was trying to access.

Running ./manage.py reset_db from django-extensions, worked fine as well, before I made sure that the user had permissions on all databases.

I would assume then that there is a bug in syncdb. After more looking into this, I might have to report a bug to Django.

👤chadgh

Leave a comment