{"id":59189,"date":"2021-01-07T13:15:31","date_gmt":"2021-01-07T19:15:31","guid":{"rendered":"https:\/\/blog.cpanel.com\/?p=59189"},"modified":"2021-01-07T13:15:31","modified_gmt":"2021-01-07T19:15:31","slug":"how-to-use-a-remote-mysql-database-with-cpanel","status":"publish","type":"post","link":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/","title":{"rendered":"How To Use A Remote MySQL<sup>\u00ae<\/sup> Database With cPanel"},"content":{"rendered":"\n<p>The MySQL database server is a core component of millions of content management systems and ecommerce apps. It provides the secure and reliable data storage and retrieval that makes dynamic, personalized websites possible. cPanel &amp; 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.<\/p>\n\n\n\n<p>Typically, websites and cPanel\u2019s MySQL instance are installed on the same server. However, it\u2019s sometimes useful to separate them so that sites use a remote MySQL database hosted on a different server.<\/p>\n\n\n\n<p>You might use a remote MySQL server to:<\/p>\n\n\n\n<ul><li>Offload database workloads from the webserver to improve the performance of busy sites and the database.<\/li><li>Use a server specifically configured for database hosting.<\/li><li>Centralize database management for multiple servers.<\/li><li>Isolate the database from servers accessible via a public IP address.<\/li><\/ul>\n\n\n\n<p>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. As you may appreciate, this method creates a <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/security-guidelines.html\">critical security vulnerability<\/a> that is often exploited to steal sensitive data.<\/p>\n\n\n\n<p>In this article, we\u2019ll 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.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Using a Remote Database to Host Your Site\u2019s Data<\/strong><\/h2>\n\n\n\n<p>To follow this tutorial, you will need:<\/p>\n\n\n\n<ul><li>A server with cPanel &amp; WHM installed. This will be the remote database server.<\/li><li>The database server\u2019s IP address or domain name, cPanel authentication credentials, and MySQL username and password.<\/li><li>A server on which to install web applications. The method we\u2019re about to describe will work if you install and configure sites manually, but it is faster and more convenient with cPanel.<\/li><\/ul>\n\n\n\n<p>First, we\u2019ll explain how cPanel users can configure a remote MySQL database before looking at WHM\u2019s MySQL Profile management tools.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Configuring a Remote MySQL Database with cPanel<\/strong><\/h2>\n\n\n\n<p>Log in to cPanel on the server with the MySQL instance you would like to grant access to. Select the <em>Remote MySQL<sup>\u00ae<\/sup><\/em> tool from the main page menu.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/blog.cpanel.com\/wp-content\/uploads\/2021\/01\/00-cpanel-menu-remote-mysql.png\" alt=\"cPanel Menu Remote MySQL\" class=\"wp-image-59193\"\/><\/figure>\n\n\n\n<p>In the <em>Add Access Host<\/em> form, enter the domain name or IP address of the server that hosts the web application. You can add a wildcard (%) to allow multiple IP addresses to access the database; for example, 192.68.0%. When using a wildcard, be sure to limit the scope to addresses under your control or that you are confident pose no security risk.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/blog.cpanel.com\/wp-content\/uploads\/2021\/01\/01-cpanel-remote-mysql-manager.png\" alt=\"cPanel Remote MySQL Manager\" class=\"wp-image-59197\"\/><\/figure>\n\n\n\n<p>Click the <em>Add Host <\/em>button, and cPanel configures the MySQL database to accept requests from the remote site.<\/p>\n\n\n\n<p>Next, you should configure the site to use the remote database. The process differs depending on the application. For example, on a newly installed WordPress site, you would first create the database in cPanel\u2019s <em>MySQL\u00ae Database Wizard<\/em>.&nbsp;<\/p>\n\n\n\n<p>Then, edit the WordPress site\u2019s <em>wpconfig.php<\/em> to include the database name and authentication credentials, as well as the server\u2019s domain name or IP address.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define( 'DB_NAME', 'wp_database' );\ndefine( 'DB_USER', 'user' );\ndefine( 'DB_PASSWORD', 'a-secure-password' );\ndefine( 'DB_HOST', '203.0.113.0' );<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Adding MySQL Access Hosts in WHM<\/strong><\/h2>\n\n\n\n<p>System administrators can also configure MySQL to accept incoming connections from sites hosted elsewhere. There are some differences between cPanel and WHM where remote database access is concerned:<\/p>\n\n\n\n<ul><li>Hosts added in WHM are applied to all cPanel user accounts and the MySQL users associated with those accounts.<\/li><li>cPanel users cannot permanently remove hosts added by system administrators in WHM.<\/li><\/ul>\n\n\n\n<p>To allow remote hosts to access MySQL databases, navigate to <em>Additional MySQL Access Hosts<\/em> in the <em>SQL Services<\/em> section of the sidebar menu.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/blog.cpanel.com\/wp-content\/uploads\/2021\/01\/02-cpanel-additional-access-hosts.png\" alt=\"cPanel Additional Access Hosts\" class=\"wp-image-59201\"\/><\/figure>\n\n\n\n<p>Enter the domain names or IP addresses of remote hosts that should be allowed to connect to the server\u2019s databases and click save. To begin to use databases on the server, you should configure your sites with the relevant IP address and authentication credentials, as described in the previous section.<\/p>\n\n\n\n<p>To learn more about database access hosts, take a look at the <a href=\"https:\/\/docs.cpanel.net\/whm\/sql-services\/additional-mysql-access-hosts\/\">feature\u2019s documentation page<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Managing MySQL Profiles in WHM<\/strong><\/h2>\n\n\n\n<p>In addition to configuring remote databases in cPanel &amp; WHM, server administrators can create <a href=\"https:\/\/docs.cpanel.net\/whm\/sql-services\/additional-mysql-access-hosts\/\">MySQL profiles<\/a> in WHM to connect with remote database servers. A MySQL Profile allows administrators to define the remote database used throughout cPanel &amp; WHM; in fact, the local machine\u2019s default database is configured via a profile.<\/p>\n\n\n\n<p>Profiles can be used to configure several types of remote databases, including those running on other cPanel &amp; WHM servers, dedicated MySQL servers, and databases running on Amazon\u2019s Relational Database&#x2122; Service.<\/p>\n\n\n\n<p>Before you create and activate a new profile, you should be aware that only one MySQL profile can be active at any time. To add a new profile, log in to WHM and navigate to <em>Manage MySQL\u00ae Profiles<\/em> under <em>SQL Services<\/em> in the sidebar menu.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/blog.cpanel.com\/wp-content\/uploads\/2021\/01\/03-cpanel-whm-mysql-profiles.md_.png\" alt=\"cPanel WHM MySQL Profiles\" class=\"wp-image-59205\"\/><\/figure>\n\n\n\n<p>WHM can log in to the server, create a new MySQL superuser to manage databases, and configure MySQL. If you have already configured the MySQL installation with a superuser, you can add those details instead.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/blog.cpanel.com\/wp-content\/uploads\/2021\/01\/04-cpanel-new-mysql-profile.png\" alt=\"cPanel New MySQL Profile\" class=\"wp-image-59209\"\/><\/figure>\n\n\n\n<p>Once you have activated the profile, new databases are created on the remote server. However, existing databases are not automatically migrated, and you will need to transfer data manually.<\/p>\n\n\n\n<p>cPanel &amp; WHM gives web hosts and their clients incredible flexibility when configuring and managing MySQL databases. They can take advantage of:<\/p>\n\n\n\n<ul><li>Outstanding out-of-the-box defaults for hosting MySQL databases on the local server.<\/li><li>Easy database configuration for sites and stores hosted on remote servers.<\/li><li>System administrator tools that give admins complete control over MySQL and where their databases are hosted.<\/li><\/ul>\n\n\n\n<p>As always, if you have any feedback or comments, please let us know. We are here to help in the best ways we can. You\u2019ll find us on <a href=\"https:\/\/go.cpanel.net\/discord\">Discord<\/a>, the <a href=\"https:\/\/forums.cpanel.net\">cPanel forums<\/a>, and <a href=\"https:\/\/reddit.com\/r\/cpanel\">Reddit<\/a>. Be sure to also follow us on&nbsp;<a href=\"https:\/\/facebook.com\/cpanel\">Facebook<\/a>,&nbsp;<a href=\"https:\/\/instagram.com\/cpanel\">Instagram<\/a>, and&nbsp;<a href=\"https:\/\/twitter.com\/cpanel\">Twitter<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The MySQL database server is a core component of millions of content management systems and ecommerce apps. It provides the secure and reliable data storage and retrieval that makes dynamic, personalized websites possible. cPanel &amp; WHM is a complete MySQL management solution that automates many common web hosting database tasks while offering fine-grained control to [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":65645,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[61],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Use A Remote MySQL\u00ae Database With cPanel | cPanel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Use A Remote MySQL\u00ae Database With cPanel | cPanel\" \/>\n<meta property=\"og:description\" content=\"The MySQL database server is a core component of millions of content management systems and ecommerce apps. It provides the secure and reliable data storage and retrieval that makes dynamic, personalized websites possible. cPanel &amp; WHM is a complete MySQL management solution that automates many common web hosting database tasks while offering fine-grained control to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"cPanel\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cpanel\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-07T19:15:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devel.www.cpanel.net\/wp-content\/uploads\/2021\/01\/How-To-Use-A-Remote-MySQL-Database-With-cPanel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2048\" \/>\n\t<meta property=\"og:image:height\" content=\"811\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"cPanel Community\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cPanel\" \/>\n<meta name=\"twitter:site\" content=\"@cPanel\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"cPanel Community\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/\",\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/\",\"name\":\"How To Use A Remote MySQL\u00ae Database With cPanel | cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\"},\"datePublished\":\"2021-01-07T19:15:31+00:00\",\"dateModified\":\"2021-01-07T19:15:31+00:00\",\"author\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\"},\"breadcrumb\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/devel.www.cpanel.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Use A Remote MySQL\u00ae Database With cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\",\"url\":\"https:\/\/devel.www.cpanel.net\/\",\"name\":\"cPanel\",\"description\":\"Hosting Platform of Choices\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devel.www.cpanel.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\",\"name\":\"cPanel Community\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"caption\":\"cPanel Community\"},\"description\":\"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.\",\"sameAs\":[\"https:\/\/cpanel.net\"],\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Use A Remote MySQL\u00ae Database With cPanel | cPanel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How To Use A Remote MySQL\u00ae Database With cPanel | cPanel","og_description":"The MySQL database server is a core component of millions of content management systems and ecommerce apps. It provides the secure and reliable data storage and retrieval that makes dynamic, personalized websites possible. cPanel &amp; WHM is a complete MySQL management solution that automates many common web hosting database tasks while offering fine-grained control to [&hellip;]","og_url":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/","og_site_name":"cPanel","article_publisher":"https:\/\/www.facebook.com\/cpanel\/","article_published_time":"2021-01-07T19:15:31+00:00","og_image":[{"width":2048,"height":811,"url":"https:\/\/devel.www.cpanel.net\/wp-content\/uploads\/2021\/01\/How-To-Use-A-Remote-MySQL-Database-With-cPanel.png","type":"image\/png"}],"author":"cPanel Community","twitter_card":"summary_large_image","twitter_creator":"@cPanel","twitter_site":"@cPanel","twitter_misc":{"Written by":"cPanel Community","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/","url":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/","name":"How To Use A Remote MySQL\u00ae Database With cPanel | cPanel","isPartOf":{"@id":"https:\/\/devel.www.cpanel.net\/#website"},"datePublished":"2021-01-07T19:15:31+00:00","dateModified":"2021-01-07T19:15:31+00:00","author":{"@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8"},"breadcrumb":{"@id":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devel.www.cpanel.net\/blog\/tips-and-tricks\/how-to-use-a-remote-mysql-database-with-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devel.www.cpanel.net\/"},{"@type":"ListItem","position":2,"name":"How To Use A Remote MySQL\u00ae Database With cPanel"}]},{"@type":"WebSite","@id":"https:\/\/devel.www.cpanel.net\/#website","url":"https:\/\/devel.www.cpanel.net\/","name":"cPanel","description":"Hosting Platform of Choices","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devel.www.cpanel.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8","name":"cPanel Community","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","caption":"cPanel Community"},"description":"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.","sameAs":["https:\/\/cpanel.net"],"url":"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/59189"}],"collection":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/comments?post=59189"}],"version-history":[{"count":0,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/59189\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media\/65645"}],"wp:attachment":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media?parent=59189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/categories?post=59189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/tags?post=59189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}