Skip to content

Cookie settings

Choose which kinds of cookies you allow. You can change your choice at any time via Cookie settings at the bottom of every page. Privacy statement

Necessary

Always on

Needed to log in, keep your cart and remember your choices. These are always on.

Which cookies?
  • weboke_sessie, weboke_klant, weboke_remember: your session and staying logged in
  • weboke_basket: your cart
  • wkBtwIncl: showing prices with or without VAT
  • wok_cookies: your cookie choice, 12 months

Measures which ad leads to a visit or order, so we do not pay for ads that do nothing.

Which cookies?
  • Google Ads via Google Tag Manager (_gcl_au, _gcl_aw), up to 90 days
  • OpenAI Ads, ads in ChatGPT
  • wok_aff: which partner referred you to us (affiliate programme), 60 days

4.6

Country and language

Each country has its own site, with prices and VAT for that country.

View

How do I connect to my hosting database from my PC?

With a program on your computer, such as HeidiSQL, DBeaver, MySQL Workbench or TablePlus, you can work directly with your database on our servers. You do this through an SSH tunnel. For that you need a package with SSH: Power Webhost Three, Power Webhost Four, AI Wordpress Three or Power Reseller.

Why an SSH tunnel and not port 3306?

Database port 3306 is closed to the internet on our servers. An open database port is attacked all day long by bots trying to guess passwords, and a regular database connection is often not encrypted. Access by IP address only helps halfway: your IP address changes now and then and is often shared with others. With an SSH tunnel you log in with your SSH key, everything is encrypted and you don't need to add an IP address.

How to connect

  1. Add your SSH key in DirectAdmin under SSH Keys (see SSH Keys and logging in with SSH).
  2. In your program, choose the connection via SSH: in HeidiSQL MariaDB or MySQL (SSH tunnel), in DBeaver the SSH tab, in MySQL Workbench Standard TCP/IP over SSH.
  3. SSH: the server name of your package (for example linux2024.webawere.nl), port 1967, your DA username and your private key.
  4. Database: host 127.0.0.1, port 3306, and the full names of the database and user, prefixed with your DA username and an underscore, for example wtsilefl_shop.

On the command line (Mac, Linux, Windows Terminal) you create the tunnel like this:

ssh -p 1967 -N -L 3307:127.0.0.1:3306 gebruikersnaam@linux2024.webawere.nl

Then connect in your program to 127.0.0.1, port 3307.

No SSH in your package? Switch to a package with SSH: in My WebOké, go to My Products, open your package and choose a different package on the Change hosting package card. For a database connection from your computer you don't need to add an IP address under Access Hosts; addresses or % listed there do not grant access from outside.

See also in the DirectAdmin manual: Database users, privileges and passwords.

Detailed explanation with screenshots: Connecting to your database from outside in the DirectAdmin manual.

Was this article helpful?

← Back to General hosting

One moment…

Set up your domains

For each domain, arrange the nameservers, the link to your hosting and who becomes the owner.

Loading your domains…