External database access on Flex servers (tunnel)

Our Managed Flex Servers are configured in such a way that the database cannot be accessed from outside.
Connecting with a program such as MySQL Workbench requires an SSH tunnel.

tunnel

This screen displays a new "MySQL Workbench" connection. Change the fields as following:

  1. Set the Connection Method field to Standard TCP/IP over SSH.
  2. Enter your SSH hostname in the SSH Hostname field. You can find the SSH hostname in the Hostpoint Control Panel by clicking on "Services" at the top, opening your webhosting and then clicking on "Server Overview" to the left. You will now see the SSH hostname in the top right corner.
  3. Type your SSH username in the SSH Username field. Your SSH username is the same as the name of your server.
  4. Enter your SSH password by clicking "Store in Keychain...."
  5. Enter your database host in the MySQL Hostname field. You can find your database host in the Hostpoint Control Panel by clicking on "Services" at the top, opening your webhosting and then clicking on "Databases" to the left. Now click on the desired database to view the host.
  6. Enter 3306 in the MySQL Server Port field
  7. Enter your database username in the Username field.
  8. Enter your database password by clicking "Store in Keychain...."

You can now test the connection by clicking Test Connection.

Of course, these settings also apply to all other MySQL programs that can connect via SSH tunnel.

If the external database connection is not made with a MySQL program, but e.g. with a webpage, the connection via SSH tunnel will not work.

In this case there would still be the possibility to make the MySQL server externally accessible by forwarding the MySQL server port. To do this, contact our technical support at This email address is being protected from spambots. You need JavaScript enabled to view it..

 

Unable to find what you were looking for?

Our support experts are happy to assist you personally!

 

© 2001 - Hostpoint AG