{"id":2862,"date":"2021-10-11T06:52:56","date_gmt":"2021-10-11T06:52:56","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2862"},"modified":"2021-10-11T06:52:56","modified_gmt":"2021-10-11T06:52:56","slug":"how-to-enable-remote-mysql-in-the-domain-cpanel-interface","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/","title":{"rendered":"How to Enable Remote MySQL in the Domain cPanel Interface?"},"content":{"rendered":"<p>In cPanel servers, remote MySQL connections are disabled by default as they&#8217;re considered as a potential security threat. it&#8217;s possible to add remote hosts with the help of tools within the domain-level cPanel interface that the server permits to connect to the MySQL service.<\/p>\n<p>Prior to using the subsequent technique, you&#8217;ll have to be compelled to open up port 3306 in your server\u2019s firewall<\/p>\n<p>Let&#8217;s see the steps to Enable Remote MySQL within the Domain cPanel Interface<\/p>\n<p>1. Log in to the interface of the domain\u2019s cPanel and look for the section of Databases on the main page.<\/p>\n<p>2. Then in the Databases section, search for the Remote MySQL link\/button and click on it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2863\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/remote-mysql-1.png\" alt=\"\" width=\"150\" height=\"150\" \/><\/p>\n<p>3. you&#8217;ll see the below page in your browser. Next, add an IP address or hostname to that you would like to permit remote MySQL access to (1) and so click on the Save button (2).<\/p>\n<p>4. If an IP address or host needs to be removed from this list, then you&#8217;ll click on the \u2018Delete\u2019 button simply next to the entry within the list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2864\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/remote-mysql-2.png\" alt=\"remote-mysql-2\" width=\"150\" height=\"150\" \/><\/p>\n<p>5. After all the changes, additions or removals are done to the list, you&#8217;ll return to the main page of the cPanel interface or logout, if you&#8217;ve completed alternative tasks.<\/p>\n<p>Thus by following the above steps you can enable remote MySQL in the domain cPanel interface.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In cPanel servers, remote MySQL connections are disabled by default as they&#8217;re considered as a potential security threat. it&#8217;s possible to add remote hosts with the help of tools within the domain-level cPanel interface that the server permits to connect to the MySQL service. Prior to using the subsequent technique, you&#8217;ll have to be compelled [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-2862","post","type-post","status-publish","format-standard","hentry","category-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Enable Remote MySQL in the Domain cPanel Interface? - OWS KB<\/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:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Enable Remote MySQL in the Domain cPanel Interface? - OWS KB\" \/>\n<meta property=\"og:description\" content=\"In cPanel servers, remote MySQL connections are disabled by default as they&#8217;re considered as a potential security threat. it&#8217;s possible to add remote hosts with the help of tools within the domain-level cPanel interface that the server permits to connect to the MySQL service. Prior to using the subsequent technique, you&#8217;ll have to be compelled [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-11T06:52:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/remote-mysql-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/remote-mysql-1.png\",\"width\":150,\"height\":150},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/\",\"name\":\"How to Enable Remote MySQL in the Domain cPanel Interface? - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/#primaryimage\"},\"datePublished\":\"2021-10-11T06:52:56+00:00\",\"dateModified\":\"2021-10-11T06:52:56+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-remote-mysql-in-the-domain-cpanel-interface\/\",\"name\":\"How to Enable Remote MySQL in the Domain cPanel Interface?\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=2862"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2862\/revisions"}],"predecessor-version":[{"id":2865,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2862\/revisions\/2865"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=2862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=2862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=2862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}