MySQL Forums
Forum List  »  MySQL Workbench

Remote Access to MySQL Database
Posted by: jimbo pruett
Date: August 16, 2020 11:42AM

I currently use phpmyadmin on nearlyfreespeech.net

I want to use the wonderful mysql workbench since it supports multiple sql's...


How to I do it? My provider said I must use port forwarding like this.

YourPrompt> ssh -N -L 3306:your.db:3306 user_site@ssh.xxx.nearlyfreespeech.net


I tried this:
netsh interface portproxy add v4tov4 listenaddress=127.0.0.1 listenport=3306 connectaddress=carterson2_wikispeedia@ssh.phx.nearlyfreespeech.net connectport=3306

and I tried this:

ssh -N -L 3306:registration.db:3306 carterson2_wikispeedia@ssh.phx.nearlyfreespeech.net

Note: in workbench, I use this:
https:/www.wikispeedia.org/untitled.png

It never connects.... It never asks for pw....
(aside: I swear I did this in the past, but now it doesn't connect...)

Any help appreciated.


Stay safe!

Options: ReplyQuote


Subject
Views
Written By
Posted
Remote Access to MySQL Database
161
August 16, 2020 11:42AM


Sorry, only registered users may post in this forum.

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.