following your steps when connecting to mysql and running the migrations I ran into an issue where the mysqlclient connector was not working. It seems to be an architecture issue with the M1 chip. To work-around the problem I followed the information provided by this site: How to use PyMySQL with Django - Adam Johnson
This allowed me to run the migrations successfully. Thought you would like to know.