# dbt-core having issues with establishing connection with mysql

**URL:** <https://discourse.getdbt.com/t/dbt-core-having-issues-with-establishing-connection-with-mysql/20397>\
**Category:** Show and Tell\
**Tags:** dbt-core\
**Created:** [November 5, 2025, 11:15am UTC](https://discourse.getdbt.com/t/dbt-core-having-issues-with-establishing-connection-with-mysql/20397 "2025-11-05T11:15:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![krishnanravi](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@krishnanravi](https://discourse.getdbt.com/u/krishnanravi)\
**Post date:** [November 5, 2025, 11:15am UTC](https://discourse.getdbt.com/t/dbt-core-having-issues-with-establishing-connection-with-mysql/20397/1 "2025-11-05T11:15:20Z")

</div>

Hi,

I have a dbt-core setup to connect to mysql database which is installed on a localhost on my personal machine. The connectivity from dbt-core to mysql was working fine until I recently upgraded dbt-core to the latest version.

As the latest dbt-core is incompatible with the latest mysql plugin, I have reverted dbt-core to the previous setup and then I face this weird issue that when I execute “dbt run” or “dbt snpashot” it runs without any error, but it is not connecting to the database.

I have verified the database is up and running on the localhost, I have verified profile.yml and db credentials, I have done a complete “dbt clean” and even deleted existing python virtual environment and created new but still no luck.

I see that “dbt run” or “dbt snapshot” is trying to create a new connection with mysql and then stopped without any errors and no further tracing.

(dbt-venv) PS C:\Users\krish\OneDrive\Desktop\Learning\dbt\_repo\mysql\> **dbt snapshot --select tmp\_snapshot --debug**  
11:01:12 Sending event: {‘category’: ‘dbt’, ‘action’: ‘invocation’, ‘label’: ‘start’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x000002362EBE6510\>, \<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x000002363179C050\>, \<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x000002363179C190\>]}  
11:01:12 Running with dbt=1.7.19  
11:01:12 running dbt with arguments {‘printer\_width’: ‘80’, ‘indirect\_selection’: ‘eager’, ‘log\_cache\_events’: ‘False’, ‘write\_json’: ‘True’, ‘partial\_parse’: ‘True’, ‘cache\_selected\_only’: ‘False’, ‘profiles\_dir’: ‘C:\Users\krish\.dbt’, ‘version\_check’: ‘True’, ‘warn\_error’: ‘None’, ‘log\_path’: ‘C:\Users\krish\OneDrive\Desktop\Learning\dbt\_repo\mysql\logs’, ‘debug’: ‘True’, ‘fail\_fast’: ‘False’, ‘use\_colors’: ‘True’, ‘use\_experimental\_parser’: ‘False’, ‘no\_print’: ‘None’, ‘quiet’: ‘False’, ‘warn\_error\_options’: ‘WarnErrorOptions(include=, exclude=)’, ‘invocation\_command’: ‘dbt snapshot --select tmp\_snapshot --debug’, ‘log\_format’: ‘default’, ‘introspect’: ‘True’, ‘target\_path’: ‘None’, ‘static\_parser’: ‘True’, ‘send\_anonymous\_usage\_stats’: ‘True’}  
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘project\_id’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x0000023631857950\>]}  
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘adapter\_info’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x000002363194B020\>]}  
11:01:13 Registered adapter: mysql=1.7.0  
11:01:13 checksum: a8d43cdff37d0f32d7fbe4c5c25bea4bb6c86e162f8ce8fdb1a38cdcf7495431, vars: {}, profile: , target: , version: 1.7.19  
11:01:13 Partial parsing enabled: 0 files deleted, 0 files added, 0 files changed.  
11:01:13 Partial parsing enabled, no changes found, skipping parsing  
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘load\_project’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x0000023631B22B50\>]}  
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘resource\_counts’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x00000236319873E0\>]}  
11:01:13 Found 12 models, 8 snapshots, 1 test, 24 sources, 0 exposures, 0 metrics, 491 macros, 0 groups, 0 semantic models  
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘runnable\_timing’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x0000023632B57070\>]}  
11:01:13  
11:01:13 Acquiring new mysql connection ‘master’  
11:01:13 Acquiring new mysql connection ‘list\_schemas’  
11:01:13 Using mysql connection “list\_schemas”  
11:01:13 On list\_schemas: /\* {“app”: “dbt”, “dbt\_version”: “1.7.19”, “profile\_name”: “mysql”, “target\_name”: “dev”, “connection\_name”: “list\_schemas”} \*/  
select distinct schema\_name  
from information\_schema.schemata  
**11:01:13 Opening a new connection, currently in state init**  
(dbt-venv) PS C:\Users\krish\OneDrive\Desktop\Learning\dbt\_repo\mysql\>