Skip to main content

Power BI

Under Review

MySQL over SSH connection

Vote (808) Share
Antons Fedorenko's profile image

Antons Fedorenko on 28 Jan 2015 18:10:27

Comments (178)
Antons Fedorenko's profile image Profile Picture

Michel Ulens on 26 Sep 2024 09:56:15

RE: MySQL over SSH connection

We need this too. Strange that it isn't there yet. This is becoming the standard...

Antons Fedorenko's profile image Profile Picture

VINOD KUMAR on 29 Feb 2024 04:48:07

RE: MySQL over SSH connection

This feature is very important. Please develope it asap.

Antons Fedorenko's profile image Profile Picture

Edgar Walther on 23 Oct 2023 13:44:40

RE: MySQL over SSH connection

We need this too. Strange that it isn't there yet. Seems like a common way to connect to unix/linux hosted databases.

Antons Fedorenko's profile image Profile Picture

Nick Oetjen on 27 Sep 2023 07:28:48

RE: MySQL over SSH connection

Hi, this really is essential. The MariaDB is on a linux webserver, and needs to be connected with SSH from the Windows based server. This setup will exists millions of times.

Antons Fedorenko's profile image Profile Picture

Manish Ghimire on 22 May 2023 17:29:21

RE: MySQL over SSH connection

This feature is very essential. Companies usually have their database inside a cloud and every time I try to connect to them, SSH Tunnelling becomes my headache. OBDC is a very lengthy and confusing way.

Antons Fedorenko's profile image Profile Picture

Joshua Gulledge on 23 Mar 2023 12:57:32

RE: MySQL over SSH connection

This feature would be great to have! I need to connected to some web servers that are set up on Cloudways.com.

Antons Fedorenko's profile image Profile Picture

Ramkumar Srinivasan on 10 Nov 2022 11:46:48

RE: MySQL over SSH connection

much needed feature

Antons Fedorenko's profile image Profile Picture

pavankumar balabhadra on 13 Apr 2022 09:25:45

RE: MySQL over SSH connection

HiWe need this option and I need to build 1000 of reports with Azure Mysql SSH connection. Business will not agree to take this tool going in future.REgardsB Pavan Kumar

Antons Fedorenko's profile image Profile Picture

Edward QI on 22 Feb 2022 09:06:20

RE: MySQL over SSH connection

Please develop thissss!!

Antons Fedorenko's profile image Profile Picture

Peter Chifamba on 27 May 2021 17:27:57

RE: MySQL over SSH connection

MYSQL over ssh connection
1. download the latest ODBC connector for MySQL and install on windows
2. Install the ODBC drivers on Windows computer
3. Configure a DSN for ODBC Driver in windows 10 -- run dialog box by pressing Windows+R and click OK
4. Enter command odbcad32 and press ENTER
5. On ODBC Data Source Administrator under User DSN, click the Add button
6. Under "Create New Data Source" Select the driver you installed and click finish.
7. A new window appears for MySQL connector/ODBC type localhost under TCP/IP Server and port 3306.
Enter username and password for and click OK
8. close
9. download putty software and install it
10. Start PuTTY.
11. In the Category pane, expand Connection, expand SSH, and then click Tunnels.
12. In the Source port text box of the Port Forwarding section, type 3306. This is the local port to forward.In the Destination text box, type localhost:3306.
13. Confirm that the Local and Auto radio buttons are selected.
14. Click Add:
15. In the Category pane, click Session.
16. In the Host Name (or IP address) text box, type your web site's domain name or IP address.
17. In the Port text box, type 7822.
18. Confirm that the Connection type radio button is set to SSH.
19. Click Open:
20. If a PuTTY security alert about the server's host key appears, click Yes.
21. When the login as prompt appears, type your A2 Hosting username, and then type your password.
22. When the remote server's command line prompt appears, the SSH tunnel is established and you can use your MySQL client applications on the local computer.

23. Open power BI
24. Select Get data from the Data source at the top
25. Select database MySQL database for localhost:3306