Error opening connection getaddrinfo ENOTFOUND db[XXXXXXXXXX].hosting-data.io

[FrankCoder]

SQLTOOLS fails to connect to my ionos hosted mysql 8 db using the same server, port, database, user, name and password I use for my app to connect, which connects flawlessly.

The error returned is "Error opening connection getaddrinfo ENOTFOUND db[XXXXXXXXXX].hosting-data.io"

To Reproduce { "mysqlOptions": { "authProtocol": "xprotocol", "enableSsl": "Disabled" }, "previewLimit": 500, "server": "dbXXXXXXXXXX.hosting-data.io", "port": 33060, "driver": "MySQL", "name": "mgmt-db", "group": "Production", "database": "dbsXXXXXXX", "username": "dbuXXXXXXX", "password": "***", "connectionTimeout": 15 }

Not going to provide credentials at this moment, can setup separated DB for reproduction if necessary. I did triple check the values. My password is 24 characters long, do you have a limit?

Desktop (please complete the following information):

• SQLTools Version v0.28.0
• VS Code Version: 1.80.2 (Universal) Commit: 2ccd690cbff1569e4a83d7c43d45101f817401dc Date: 2023-07-27T21:05:41.366Z (4 hrs ago) Electron: 22.3.14 ElectronBuildId: 22695494 Chromium: 108.0.5359.215 Node.js: 16.17.1 V8: 10.8.168.25-electron.0 OS: Darwin arm64 22.5.0
• Driver:
  • [ ] PostgreSQL/Redshift
  • [ X] MySQL/MariaDB
  • [ ] MSSQL/Azure
  • [ ] SQLite
  • [ ] Other? Which...
• Database version: MySQL v8

[FrankCoder]

This is a limitation with IONOS. Db is not accessible outside their network.