Forum Discussion

vsorensen's avatar
vsorensen
Frequent Visitor
3 years ago
Solved

Connect to MySQL Database with Hostname via SSH Tunnel

Hi everyone,   I am facing the following issue: I would like to connect to a mysql database with a hostname using an SSH tunnel. The SSH tunnel is already configured using Putty. I have the server ...
Need Help
  • vsorensen's avatar
    vsorensen
    3 years ago

    The problem was with the database, there were additional firewalls that I could not get passed, even with the SSH tunnel. 

     

    To test the database connection over an SSH tunnel, follow these instructions (in local Windows):

    1. Open Command Prompt
    2. Enter the following prompts:
    powershell
    Test-NetConnection hostname -port xxxx

     

    If the connection fails, Power BI will not be able to connect to the database. 

vsorensen's avatar
vsorensen
Frequent Visitor
3 years ago

The problem was with the database, there were additional firewalls that I could not get passed, even with the SSH tunnel. 

 

To test the database connection over an SSH tunnel, follow these instructions (in local Windows):

  1. Open Command Prompt
  2. Enter the following prompts:
powershell
Test-NetConnection hostname -port xxxx

 

If the connection fails, Power BI will not be able to connect to the database. 

dinamo's avatar
dinamo
New Member
2 years ago

I get a TcpTestSucceeded: True on that but I am still unable to connect to the database. Any help would be appreciated.