dbt connection with mysql server

[lenokwar]

I am using the package mysql-connector-python version 9.1.0.

When I run dbt debug in the terminal to test the MySQL connection in profiles.yml, the expected line Connection test: [OK connection ok] is missing in the output.

However, after downgrading to an older version of mysql-connector-python (e.g., pip install mysql-connector-python==8.0.29), the missing line appears

Steps To Reproduce

1. Install dbt-core and dbt-mysql: bash pip install dbt-core dbt-mysql

2. Initialize a dbt project: bash dbt init

4. Run dbt debug in the terminal: bash dbt debug

The output of dbt --version:

Core:
  - installed: 1.7.19

The operating system you're using: Windows 10 Home x64 bit

The output of python --version: python3.12