![]() ![]() 3306 and the remote host and port number. Here we add in the default port for MySQL server i.e. The first step is to fill in the SSH client connection configuration as follows. The solution is comprehensive and includes a facility for creating tunnels over which we will connect to our database server with encrypted communications. PuTTY is a free implementation of Telnet and SSH for Windows and UNIX platforms. ![]() We test again after the tunnel has been created and this succeeds and again we test when the tunnel is closed again and we can see that this attempt fails.įor our tests we are going to use PuTTY and MySQL Workbench. ![]() In the example below we can see that we attempt a connection prior to enabling the tunnel which fails. The connection should be to hostname 127.0.0.1 and port 3306 which redirects across the tunnel to linux and port 3306. We now need to configure MySQL Workbench. To access the service we need to access the service at localhost (127.0.0.1) and port:3306. If you attempt to logout then the tunnel will disappear.Īt this point the tunnel has been created. IT Integrated Business Solutions (c) should be noted at this point that the tunnel remains open as long as this connection remains alive. You must complete the login process in order to setup the tunnel. The -L option specifies that a local port on the local (client) host is to be forwarded to the given host and port on the remote side. On UNIX/Linux and Mac OS X, if the ssh packages have been installed we can setup the tunnel with a single command issued from the command line: $ ssh -L port:host:hostport host} We shall deal with each of these separately in the next sections. However, on Windows platform SSH is not available and needs to either be installed or a separate package used to complete the tunnel. As UNIX/Linux/Mac OS X has the ssh package the configuration of the tunnel is possible from the command line. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |