MySQL Forums
Forum List  »  Newbie

Re: How to connect to a remote mySQL server? please help!
Posted by: rol and
Date: September 07, 2014 09:15AM

This is fairly simple, i have a question though..
when you say "remote desktop" do you mean RDP as in this is a windows server?

First of all, you can use mysqlwork bench and setup "ssh" connection to the server.
workbench client will handle ssh authentication and allow u to work on ur DB after you authenticate to it.

on the other hand, if you don't want to do that and prefer to use your terminal directly...
you can setup an ssh tunnel between any port of your choice on your own machine and map it to the remote server with port 3306 (assuming mysql is running on default port) and voila, you can now connect.

either way are possible and fairly simple.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to connect to a remote mySQL server? please help!
September 07, 2014 09:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.