Sometimes you may just want a basic tunnel as your users may wish to use their own clients to connect to a service or you want to use a direct connection from the client OS to the end service.
This article shows how to connect to a remote mySQL database.
- mySQL set up on a server and remote access granted to the databases
- Hypersocket client installed on client computer
Step 1: Create a Protocol
MySQL's standard port is not available as a built-in protocol, so we first need to create it. As an administrator navigate to Network, click Protocols, then Create.
Enter a Name for the Protocol, here we have called it mySQL. Set the Transport to TCP and the Start Port and End Port to 3306, which is the standard port that mySQL uses. Click Create.
Step 2: Create a Endpoint
Now navigate to Network -> Endpoints and click Create.
Give the resource a name, here we have called it SQL, and enter a hostname. As our resource is available only on an IP address, we have to fill in both Hostname and Destination Host/IP fields. The Hypersocket client will automatically map your chosen hostname to the IP address.
Click the Protocols tab and select the new mySQL protocol and add it by clicking the right arrow button.
Click Roles and add which roles can access this resource.
Step 3: Testing the resource
Start the Hypersocket Client and connect to your server.
Click the lightning icon to view which non-launchable resources are available.
You should be able to find the mysql resource (circled below). This resource is now available on the client system to connect to.
We shall use mySQL Workbench here to show the connection to mysql_server:3306.