Remote MySQL Administration for 1and1: Windows

Posted on Saturday, June 2, 2012

9 Replies

See: Remote MySQL Administration for 1and1

Update March 12 2013: Posted a new link to Cygnative files.

As always, setting up things like this on Windows takes a bit of work. Assuming you already have Socat installed and working on your 1and1 server, I am going to dive right into the setup.

Install Pageant, PuTTY, plink.exe to ”C:\Program Files\PuTTY” (use the Windows installer from the PuTTY website)
Download Socat binaries from Gentle Kiwi and extract socat-x.x.x.zip to the PuTTY installation directory.
~~Download cygnative from Beerensalat~~ Download cygnative and extract cygnative1.2.zip to the PuTTY installation directory
Copy mysql-remote.bat to the PuTTY installation directory (see below)
Right click My Computer → Properties → Advanced → Environment Variables, and add the PuTTY installation directory to the PATH
Create PuTTY private key (*.ppk) files, so that you don’t need to provide a password for the SSH connection
Test the mysql-remote.bat script

mysql-remote.bat

@echo off

echo Connecting to %1:%2
echo Listening on port %3
socat tcp-l:%3,forever,fork exec:'cygnative plink %1 "socat stdio unix:%2"'
pause

Usage: mysql-remote <host> <path_to_socket_on_remote> <local_listening_port>

Once established connect to MySQL via localhost and the local listening port.

http://www.2upmedia.com Orlando Web Developer

I followed your other post on doing this for linux. I was getting a socat not found error so I modified the bat file to this:

@echo off

echo Connecting to %1:%2
echo Listening on port %3
socat tcp-l:%3,forever,fork exec:’cygnative plink %1 “~/opt/usr/bin/socat stdio unix:%2″‘
pause

I didn’t know what to user for . I’m on a shared 1and1 account and mysql isn’t running on the server so there isn’t a sock file. I used /var/run/mysqld/mysqld.sock. This is a symbolic link to /tmp/mysqld.sock, which doesn’t exist so I get the following error:

2012/08/22 19:52:47 socat[13494] E connect(3, AF=1 “/var/run/mysqld/mysqld.sock”
, 110): No such file or directory

How did you get this to work?
Al

The cygnative link is dead, and appears nowhere on the Internet!

Can you provide an alternative link?

Thanks!
http://www.franklinstrube.com Franklin Strube

Thanks for the heads-up. I’ve uploaded an old version of cygnative here: http://franklinstrube.com/wp-content/uploads/2013/03/cygnative1.2.zip
Gary Thompson

Hi There, I would really like to get this working but for some reason the listening port trigger socat on port 3306 (maybe its clashing with the localhost?).

I have tried on port 3307 which starts socat but keeps saying:
“socat[5092] E execvp(“cygnative”, “cygnative”, “cygnative”, “plink”, “[email protected]”, …): No such file or directory ”

Any help would be greatly appreciated.

Thanks
G
http://www.franklinstrube.com Franklin Strube

Gary, sounds like the cygnative or plink executable is not in your PATH. Where did you extract/install them to?
Gary Thompson

Into the Putty install directory… ??
Gary Thompson

My apologies… cygnative was not in the correct directory as you suggested. We have some progress…
Gary Thompson

Now I am getting: ‘bash: socat: command not found’

Any ideas…?

Thanks for your help and support.
http://www.franklinstrube.com Franklin Strube

Actually, I think that is the server claiming that it doesn’t have a socat command (it is attempting to execute the part in quotes to the right of “plink %1″).

If you’re using 1and1, you will have to follow these instructions to get it installed on your server: http://franklinstrube.com/blog/remote-mysql-administration-for-1and1/