I was facing similar issue. Just add use_pure=True to mysql connection properties.
credits to this thread.https://stackoverflow.com/questions/65565172/python-mysql-connector-hangs-indefinitely-when-connecting-to-remote-mysql-via-ss 1