xxxxxxxxxx
pip3.6 install mysql-connector-python==8.0.29
xxxxxxxxxx
I ran into the same issue. There were apparently some changes in version 8.0.30 to the way utf8_ collations are handled (see MySQL Connector release notes).
I installed version 8.0.29 which fixed the issue for me.