BuycPanel Blog

BuycPanel Blog

Latest news and updates

The Remote MySQL

Posted by Allura on 20 09 2018.

Introduction
Remote MySQL us for cPanel and WHM version 64. One needs to navigate to (Home >> Databases >> Remote MySQL) interface to make this feature work.

This feature allows one to remote hosts (servers) to access MySQLR databases on one’s account. This can be useful in case one wishes to allow shopping cart or guestbook applications on other servers to access the databases.

As a warning it can be noted that one’s hosting provider at the server level may add remote hosts to the list. In case one notices a hostname appearing after being removed or fails to recognise it, then one can contact the hosting provider to solve the issue.

Allow a Remote Server to Access One’s Databases
Steps:

 	In the Host text box, one needs to enter the host’s name or IP address.

In that case,

 	One may enter a fully qualified domain name (FQDN) or an IP address.
 	One may use the…

Introduction

Remote MySQL us for cPanel and WHM version 64. One needs to navigate to (Home >> Databases >> Remote MySQL) interface to make this feature work.

This feature allows one to remote hosts (servers) to access MySQLR databases on one’s account. This can be useful in case one wishes to allow shopping cart or guestbook applications on other servers to access the databases.

As a warning it can be noted that one’s hosting provider at the server level may add remote hosts to the list. In case one notices a hostname appearing after being removed or fails to recognise it, then one can contact the hosting provider to solve the issue.

Allow a Remote Server to Access One’s Databases

Steps:

  • In the Host text box, one needs to enter the host’s name or IP address.

In that case,

  • One may enter a fully qualified domain name (FQDN) or an IP address.
  • One may use the ‘%’ sign character as a wildcard. For example, one can enter 192.68.0% to allow access from all IP addresses that begin with 192.68.0.
  • Next, click on Add Host.

Deny a Remote Server to Access One’s Databases

Steps:

  • One needs to click on Delete option next to the host’s name or IP address.
  • Finally, click Yes.

Conclusion

Remote MySQL helps in accessing databases on one’s account. There are technical steps to allow or deny a remote server to access one’s databases.