Soda 3.5.5 failing with mysql-connector-python==8.0.30

[braislchao]

This issue arised in Soda 3.5.5 when connecting to mysql using mysql-connector-python==8.0.30:

  | During handling of the above exception, another exception occurred:

  | Traceback (most recent call last):
  |   File "/POC/venv/soda/.venv/lib/python3.13/site-packages/soda/execution/data_source_manager.py", line 48, in get_data_source
  |     data_source.connect()
  |     ~~~~~~~~~~~~~~~~~~~^^
  |   File "/POC/venv/soda/.venv/lib/python3.13/site-packages/soda/data_sources/mysql_data_source.py", line 85, in connect
  |     raise DataSourceConnectionError(self.TYPE, e)
  | soda.common.exceptions.DataSourceConnectionError: Encountered a problem while trying to connect to mysql: Character set 'utf8' unsupported

This is related to this known connector change: https://stackoverflow.com/questions/73244027/character-set-utf8-unsupported-in-python-mysql-connector

Downgrading it to 8.0.29 fixes the problem:

pip3 install mysql-connector-python==8.0.29

Pointing this because 8.0.30 is part of test setup:

https://github.com/sodadata/soda-core/blob/0ad454c7507a74e2430cd67b695113e936495c99/soda/mysql/setup.py#L11

[tools-soda]

CLOUD-9193