In this tutorial, we will discuss how to remote MySQL in cPanel . What is remote MySQL in cPanel? Namely, using the Remote MySQL menu in cPanel so that someone can access your MySQL database. So, when you have activated the remote MySQL feature in cPanel, you can use the remote client application to access the MySQL database on your server. Remote MySQL is a bit of a high risk because you can't limit what the client does to access the database. So, be careful, Everyone!

MySQL Remote on Hosting

At KincaiHosting, you can remote MySQL database at Hosting with the following conditions:

  • For Super Hosting Packages and Above : You can follow the MySQL Remote Guide on Hosting via SSH Tunneling . You only need to SSH to the hosting then remote MySQL via SSH Tunnel
  • For Extra Hosting Packages (don't have SSH access) : You can follow this step by step guide.

Send Tickets In Advance

For those of you who don't have SSH access, please follow this guide. You need to prepare several things such as:

  • This IP Client must come from a static IP or from a DDNS (Dynamic DNS) address . You can follow the Dynamic DNS Register Guide .
  • Then please send a ticket to the Support Team to allow the IP Address or DDNS . To submit tickets, please follow the guide on How to Submit KincaiHosting Tickets
  • If it has been successfully allowed, please do it step by step according to this guide.

Note : This guide is only for hosting packages that do not have SSH (Extra Hosting Packages) access.

How to Remote MySQL in cPanel?

If your static IP address or DDNS has been allowed by the KincaiHosting Support Team, please do the following guidelines:

1. Login to cPanel

The first step you have to do is login to cPanel. CPanel login can be via https: // domainname / cpanel, according to the email sent from KincaiHosting regarding Hosting Account Information. For those of you who don't know how to log in to cPanel, please read the Easy Way to Login cPanel Hosting .

Then, write "remote mysql" in the search form. Then click menu Remote MySQL.
 

2. Adding Host / IP Client

Well, at this step you can add the IP client who wants to remote the database on the hosting / server. Of course, after our Support Team checks and allows (allow) the IP Client / DDNS on the KincaiHosting firewall.

After that you need to add a host to cPanel Hosting. Please add Static IP / DDNS address then click Tambah Host. You can also use% to allow specific IP blocks eg 10.1.10.%.
mysql remote way in cpanel

3. Remote MySQL from the Client

The client IP has been allowed to access the database. So the next step is to do remote MySQL from the client. You can remote MySQL databases using remote applications such as MySQL Workbench, HeidiSQL or Navicat.

 

How to Remove Host (IP Client)

As for how to delete the host / IP client is very easy. Please select the IP Client you want to delete then click Delete.
mysql remote way in cpanel

Conclusion

How? How to remote MySQL in cPanel is easy, right? Remote MySQL on cPanel is indeed beneficial for several parties. Especially if you have 1 database that can be accessed by multiple client computers. So that the client computer does not need to create a new database with the same data. Or change a single table / column in the database. You can also collaborate in accessing MySQL databases. However, you also need to be careful and don't forget to always backup the database. Also, make sure you trust the person remote the MySQL database. Do not let the data in the database be used for certain purposes. If you have any questions, don't hesitate to contact our Support Team. KincaiHosting is a cheap hosting provider and cheap domainsin Indonesia. Thank you for using our services. Greetings, KincaiHosting! ?

Also Read : PostgreSQL Remote Guide on Hosting

What is Safelink Asia?

Safelink.asia is a completely free tool where you can create short links. URL security with cryptographic algorithm. Protect your web visitors with a secure link, to avoid viruses, malware, thief, etc. Apart from being free, you get paid! Register now!


Shorten URLs & earn money

So, now you can make money from home, when managing and protecting your links with Safelink Asia. Signup for an account in just 1 minutes. Once you've completed your registration just start creating short URLs and sharing the links with your family and friends. See our proof of payment and publisher rate.


Our partners and network

Here are some of our partners and networks that have collaborated on advertising: 401XD Group, MC Project, Kincai Media, Kartu Nama Digital, SEO Secret Indonesia, Safelink Asia, Media Bisnis, Blackexpo, Adigunawan.net.