Connect to your MySQL database from your computer
Remotely connecting to MySQL using a MySQL client, like MySQL Workbench, may be needed to perform some tasks. To do so, an SSH tunnel must be configured. Below you will find the instructions.
Prerequisites
Access to your Funio Hub
Access your cPanel interface
MySQL client that supports SSH tunnels
Task completion: 15 minutes
Expertise: advanced
How to do it?
We will use MySQL Workbench, which is the client offered by MySQL, to configure the connection.
1- Download and install MySQL Workbench here
2- Login to cPanel, create and download the SSH Key
3- Open MySQL Workbench, click Databases → Manage Connections… → New
4- Set the name of the connection
5- Select Standard TCP/IP over SSH as the Connection Method.
6- Complete the information as follows:
SSH Hostname: your_server_name
SSH Username: Your cPanel username
SSH Password: No modification needed, leave default options
SSH Key File: Your SSH Key file
MySQL Hostname: 127.0.0.1 (localhost won’t work)
MySQL Server Port: 3306
Username: Your MySQL username
Password: Your MySQL password
Default Schema: Leave blank
7- Click Test Connection, and a message indicating a successful connection should be shown
8- Click Database > Connect to Database… > OK to create a new connection.
Important notes
When you test the connection you may receive a warning message that contains “The authenticity of ‘….’ cannot be established…“. Simply click OK to accept the authenticity of the server.
You may also receive a Warning message saying you are connecting to a “… non-standard version…”. Simply click Continue Anyway. The message is shown because we use MariaDB on our servers.