Select the Remote MySQL ® tool from the main page menu. Log in to cPanel on the server with the MySQL instance you would like to grant access to. Configuring a Remote MySQL Database with cPanel The method we’re about to describe will work if you install and configure sites manually, but it is faster and more convenient with cPanel.įirst, we’ll explain how cPanel users can configure a remote MySQL database before looking at WHM’s MySQL Profile management tools. A server on which to install web applications.The database server’s IP address or domain name, cPanel authentication credentials, and MySQL username and password.Using a Remote Database to Host Your Site’s Data In this article, we’ll show you how to do it the right way, using cPanel to securely configure MySQL to accept connections from web applications hosted on different servers. As you may appreciate, this method creates a critical security vulnerability that is often exploited to steal sensitive data. The wrong way to achieve remote database access is to expose the MySQL server to the internet and allow it to accept connections from untrusted IPs. Isolate the database from servers accessible via a public IP address.Centralize database management for multiple servers.Use a server specifically configured for database hosting.Offload database workloads from the webserver to improve the performance of busy sites and the database.However, it’s sometimes useful to separate them so that sites use a remote MySQL database hosted on a different server. Typically, websites and cPanel’s MySQL instance are installed on the same server. cPanel & WHM is a complete MySQL management solution that automates many common web hosting database tasks while offering fine-grained control to web hosts who need it. It provides the secure and reliable data storage and retrieval that makes dynamic, personalized websites possible.

The MySQL database server is a core component of millions of content management systems and ecommerce apps.

Tableplus create local database