Pulling my hair out figuring out why SQLAlchemy was giving me access denied with a legitimate account. Turned out "mysql+pymysql" failed with access denied, but "mysql+sqlconnector" succeeded. I suspect it had something to do with that "caching_sha2_password" thing.