How to connect to database using NaviCat MySQL client

Remote MySQL connection is disabled on our Shared servers due to security reasons, but you can easily set up SSH tunnel between your PC and our server using SSH-tunneling with the MySQL port (3306) forwarding. To connect to your MySQL database with Navicat software you should do the following:

1. Enable SSH access for your account using the Manage Shell cPanel plugin.

2. Open your Navicat application >> Connection >> MariaDB:



3.In the General tab, fill out the fields as follows:

Host Name/IP Address
: 127.0.0.1
Port: 3306
User Name: your database created user
Password: your database user password



3. Then, navigate to the SSH tab, check the box Use SSH tunnel and fill out the fields as shown below:

Host Name/IP address
your server hostname
Port: 21098
User Name: your cPanel username
Authentication Method: Password
Password: your cPanel password



4. Once done, press OK to save the connection settings. You will see your new connection on the left. Double-click it to connect to your database:



 
 
 

That's it!

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to import and export a database via SSH

You can easily import/export your database using phpMyAdmin menu in cPanel. To do so, follow the...

How to connect to a database using Sequel Pro

Although remote MySQL connection is disabled on our shared servers due to security reasons, you...

How to connect to a database using the Workbench MySQL client

Remote MySQL connection is disabled on our shared servers due to security reasons, but you can...

How to Duplicate a Database using phpMyAdmin

To duplicate the database follow these steps: 1. Log into cPanel >> Databases section...

How to create and maintain MySQL Databases in cPanel

This tutorial describes the process of creating and managing MySQL Databases in cPanel. There are...