My team had this same issue, or at least the behavior sounds the same. The issue for us was that the compiled code in the mysql-connector-python 9.2 version was crashing the msvcp140.dll. It turned out we had an older version of that Microsoft Runtime library. You can find the latest installer for it here: https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170#latest-microsoft-visual-c-redistributable-version
If you want to use the pure python version of the mysql.connector library in 9.2 without updating the windows runtime, you can pass in the use_pure=True argument to the connect call. See https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html for that documentation