How To Connect To A Database Using The Workbench MySQL Client

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

To connect to your MySQL database with the Workbench software you need to follow the following steps:

1. Contact our web hosting UAE support via live chat in order to enable SSH access to your account

2. Open your Workbench application

Go to Database and Connect to the database to add a new connection or click on the + icon. The setup window will appear, 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: insert 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: Enter your database username

Password: click on Store in Vault and then type in your database password

When you have done with this, you will need to re-enter your database password in the prompt window one time or even many time.

3. When you have completed this a shortcut will be added, you will be able to connect to your database by clicking on it:

In case you want any further help please contact Sky Host support desk to get resolved your issue and enjoy ultimate hosting services.