Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

antons4

MySQL over SSH connection

Submitted by on ‎01-28-2015 10:10 AM
NULL
Status: Under Review
See more ideas labeled with:
180 Comments (180 New)
Comments
duc_pham
New Member
‎07-05-2020 05:13 PM
Native SSH tunneling is needed.
juampibaldi1
New Member
‎07-05-2020 05:16 PM
Please we need this development ! Till then unfortunately we have to switch to another BI service that allows this type of connection
ninihen1
New Member
‎07-05-2020 05:16 PM
Please we need this functionality!
w_vanassche
New Member
‎07-05-2020 05:17 PM
Needed for Redshift and Psql
Nikola5
New Member
‎08-06-2020 02:48 AM
Very important feature, I hope it will be added soon!
F027827
New Member
‎03-01-2021 05:12 AM
We need ssh tunnel option to connect to PostgreSQL
jteijeira
New Member
‎03-03-2021 01:45 AM
Please develop thissss!!
tecnologia2
New Member
‎05-05-2021 08:21 PM
Help us, Microsoft !!! By the Way, Anybody knows if is it possible to connect over SSH using ODBC ? Ty
peter_chifamba
New Member
‎05-27-2021 10:27 AM
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
edward_qi
New Member
‎02-22-2022 01:06 AM

Please develop thissss!!