How to connect to databa<x>se using NaviCat MySQL client
Table of the most frequent errors in FTP clients
What permissions should be used for uploading files?
Install Apache and PHP on CentOS 7
How to Connect to a Remote Server via SSH from Windows Linux or Mac
What virtualization technology is set up on VPS?
Proxmox vs. Hyper-V: How to Choose?
21 Server Security Tips to Secure Your Server
What is the difference between Shared Hosting and Dedicated server
Resetting Dedicated server root password via Virtual Console
IIS 10: Moving an SSL Certificate to Another Server
Installing an SSL certificate on Apache
Installing an SSL Certificate on IIS 7
HTTP to HTTPS redirection on IIS
The difference between SSL and TLS
What Is a Broadcast IP Address?
How can I see and change the geolocation information about an IPv4 address block?
How do I know that the IPv4 addresses are clean and not on any blacklists?
2024-03-05 10:31:15
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!