BuycPanel Blog

BuycPanel Blog

Latest news and updates

What is the Remote MySQL Interface?

Posted by Allura on 13 06 2018.

A Brief Introduction
cPanel is a control panel which is used for web hosting. It is Linux based and has automatically systematized tools which are used for web hosting. It has various features which has made this web hosting platform quite acceptable. One such feature is the MySQL. By using this feature remote hosts (servers) can have access to MySQL® databases on the user’s  account. If the user wishes to allow shopping cart or  applications like guestbook applications on other servers to access the databases this feature can be extremely useful.

Warning:

Remote hosts  may be added by the hosting provider to this list at the server level. If a hostname is seen which cannot be recognized or removed the user must contact the hosting provider.

How to allow a remote server to access your databases?
The following steps must be performed in order to specify remote hosts that can access MySQL databases on the…

A Brief Introduction

cPanel is a control panel which is used for web hosting. It is Linux based and has automatically systematized tools which are used for web hosting. It has various features which has made this web hosting platform quite acceptable. One such feature is the MySQL. By using this feature remote hosts (servers) can have access to MySQL® databases on the user’s  account. If the user wishes to allow shopping cart or  applications like guestbook applications on other servers to access the databases this feature can be extremely useful.

Warning:

Remote hosts  may be added by the hosting provider to this list at the server level. If a hostname is seen which cannot be recognized or removed the user must contact the hosting provider.

How to allow a remote server to access your databases?

The following steps must be performed in order to specify remote hosts that can access MySQL databases on the account:-

The host’s name or IP address must be entered in the Host text box.

Notes:

  • A fully qualified domain name (FQDN) or an IP address might be entered.
  • The percentage sign character (%)might be used as a wildcard. For example, enter 68.0.%. if you want to allow access from all IP addresses that begin with 192.68.0,

How to deny a remote server access to your databases?

The following steps must be performed in order to deny database access to a remote host:-

  1. The option Delete must be clicked next to the host’s name or IP address if a database access has to be deleted from the remote host.
  2. The option Yes must be selected.

Important Aspects of MySQL

MySQL includes a comprehensive set of features, management tools and support which are technical in nature and are used to achieve high levels of MySQL security and reliability. It is an attractive feature as it reduces risk and complexity in developing and managing business-critical applications.

Concluding Note

MySQL is an essential feature of cPanel as it helps remote servers to have access to the databases of the user’s account and this document describes how to allow and deny remote server access to the databases and also gives details about some more important aspects of MySQL.