User is facing issues connecting to a local MySQL instance in Airbyte for the first time.
Can anyone here help me out? This is my first time with airbyte. I have problem connecting to my MySQL instance running locally. What am i doing wrong here?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.
I can connect it to dbeaver on that port and user creds… About the other thing, how can i check if it can listen to a local socket or not?
well, as long as it connects through dbeaver, that should be okay—some people only have it listen on a local socket and not a port, but you were able to connect via the other.
Are both running locally, or are there VMs involved? What platform?
No both are running locally in my personal machine
Are you using SSL in your Dbeaver settings? If not, expand Optional Fields and disable SSL Connection
Are you able to connect to it with another local tool like MySQL Workbench using that port and username/password?
Usually a 401 is an issue with the username or password (including that user not being associated with the target DB), but it could be that MySQL is also set up to only listen on a local socket and not the port (or there are multiple instances and the wrong one has that port, etc.