How to connect to database using Workbench MySQL client

Remote MySQL connection is disabled on our shared servers due to security reasons, but you can easily setup SSH tunnel between your PC and our server using SSH-tunneling with the MySQL port (3306) forwarding.

To connect to your MySQL database with Workbench software you should do the following:

1. Contact our hosting support via live chat or via ticket system in order to enable SSH access for your account.
2. Open your Workbench application >> Database >> Connect to database. Setup window will show up, please fill out the fields as follows:

Connection Method: Standard TCP/IP over SSH
SSH Hostname: your server hostname and port (e.g. server1.web-hosting.com:21098)
SSH Username: your cPanel username
SSH Password: click on Store in Vault … and type in your cPanel password

MySQL Hostname: 127.0.0.1
MySQL Server Port: 3306
Username: your database username
Password: click on Store in Vault … and type in your database password