4

SSH proxy and MySQL on 3rd machine

view full story
linux-howto

http://serverfault.com – I would like to connect to a remote MySQL from my host, but the host is behind a ssh proxy, like this. I have 3 hosts in this problem A: my local machine (that can ssh to B) B: Intermediate machine that can SSH to C C: a remote server running MySQL and allows only connections from localhost (grant) I use ~/.ssh/config to allow me to ssh directly from A to C (using B as proxy). Host B ProtocolKeepAlives 30 HostName hostnameofB Host C ProtocolKeepAlives 30 ProxyCommand ssh -q B nc -q0 hostnameofC 22 LocalForward 3336 localhost:3306 Port 21343 I open a ssh from A (HowTos)

dayu's picture
Submitted by dayu on 07/09/2012 – Made popular on 07/09/2012

Stories similar to SSH proxy and MySQL on 3rd machine

I'm trying to setup an ssh over https connection using nginx.

Many applications allow me to connect to Mysql using a username, password host and port. Some allow me to configure a socket instead of the host:port.

Is there any clear benefit of one over the other? I can imagine that a socket only works when MySQL is on the same machine. Is that so?

I got a great answer for my previous question about connecting from Machine A to Machine C via Socks proxy located on Machine B.

Say Machine B Ip is 218.62.97.105 and it is listening on port 1080

The command for that:

ssh -o ProxyCommand='socat - socks:218.62.97.105:HOST_C:21,socksport=1080'

I wonder if it is possible to make a chain from the socks proxies.

Consider scenario: Machine A ->

Mysql server is installed on my quest OS Centos6 (192.168.1.50) and using port 3306. I'm trying to connect from my Windows OS (192.168.1.2).

I'm getting error #1045 Access denied for user 'root'@'192.168.1.2' (using password: YES) So, as far as I understand this error is telling me that I have no rights to access mysql using user root from 192.168.1.2 host.

I'm used to setup a ssh proxy in the localhost like this:

ssh -fND 9999 server

I have been using it for years for daily browsing. Now I want to use the same proxy in a Windows guest in the same desktop host. The host (Fedora) is at 10.1.1.4 and the guest is at 10.1.1.7. But when I set the proxy as a socks5 proxy in Firefox at the Windows guest pointing it to 10.1.1.4:9999 it times out.

I've tried to setup a proxy for mysql outbound connections using TOR's 9050 port and iptables and I failed. Any ideas how to make things working?

Schema:

Linux mysql client (or PHP function) -> 127.0.0.1:9050 (TOR socks5) -> remote_mysql_server:3306

Just want to redirect any outbound connection to port 3306 through TOR proxy.

PS. pls don't ask why :)

mysql remote connection 39 weeks 2 days ago

I spoke with my host supporter to find what is my sql hostname.

He said that the only way is add permissions in mysql remote (cpanel) to my actual ip.

So the config in heidiSQL for example will be

localhost userxxx passxxx

But i have a dynamic ip, so i need to change the permissions every time, correct? Add the flag % probably is not a good idea, so how can I solve this problem?

Why I dont h

MySQL Workbech Wont Connect 2 years 46 weeks ago

I installed on my local desk workstation the MySQL Workbench application. It installed perfect and when I try to create a new connection to my database, it fails and tells me:

Quote:

Failed to Connect to MySQL at 192.168.0.79:3306 with user cmennens

I've got a redis server running on my remote machine.