[Bug] Upgrade mysql-connector-python

[anzelpwj]

Current mysql-connector-python (8.0.18) package has a security concern. I tried upgrading to 8.3.0 in a PR (#1121 ) but that could introduce a potential breaking change, so I'll make it be a separate discussion/PR.

Looking at the versions (https://dev.mysql.com/doc/connector-python/en/connector-python-versions.html) by going from 8.0.* to 8.3 we do lose some (already beyond end-of-life) connection capabilities to MySQL 5.5 and 5.6. We do, however, gain official compatibility with Python 3.12.

None of the current tests failed with the version upgrade. But worth a discussion.