{"id":6001,"date":"2018-11-06T06:36:00","date_gmt":"2018-11-06T06:36:00","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=6001"},"modified":"2022-02-12T17:40:45","modified_gmt":"2022-02-12T12:10:45","slug":"enable-remote-mysql-in-domain-cpanel-interface","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-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 are considered as a potential security threat. It is possible to add remote hosts by using tools in the domain-level cPanel interface which the server allows to connect to the MySQL service.<\/p>\n<p>Prior to using the following technique, you will need to to\u00a0open up port 3306\u00a0in your server\u2019s firewall<\/p>\n<h3>Steps to Enable Remote MySQL in the Domain cPanel Interface<\/h3>\n<p>1. Log in to the interface of the domain\u2019s cPanel and search the section of <strong>Databases<\/strong> on the main page.<\/p>\n<p>2. In the <strong>Databases<\/strong> section, find the<strong> Remote MySQL<\/strong> link\/button and click on it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6055 size-thumbnail\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/cPanel-list-min-150x150.png\" alt=\"\" width=\"150\" height=\"150\" \/><\/p>\n<p>3. You will see the below page in your browser. Next, add an IP address or hostname to which you want to allow remote MySQL access to <strong>(1)<\/strong> and then click on the <strong>Save<\/strong> button <strong>(2)<\/strong>.<\/p>\n<p>4. If an IP address or host needs to be removed from this list, you can click on the \u2018Delete\u2019 button just next to the entry in the list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6056 size-thumbnail\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/cPanel-page-fxt-min-150x150.png\" alt=\"\" width=\"150\" height=\"150\" \/><\/p>\n<p>5. After all the changes, additions or removals are done to the list, you can go back to the main page of the cPanel interface or log out, if you have completed other tasks.<\/p>\n<p>This way 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 are considered as a potential security threat. It is possible to add remote hosts by using tools in the domain-level cPanel interface which the server allows to connect to the MySQL service. Prior to using the following technique, you will need to to\u00a0open [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":6059,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230],"tags":[205,469,541],"class_list":["post-6001","post","type-post","status-publish","format-standard","has-post-thumbnail","placeholder-for-hentry","category-database","tag-mysql","tag-mysql-database","tag-remote-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Steps to Enable Remote MySQL in Domain cPanel Interface<\/title>\n<meta name=\"description\" content=\"The article reveals simple steps to enable remote MySQL in domain cPanel interface.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Steps to Enable Remote MySQL in Domain cPanel Interface\" \/>\n<meta property=\"og:description\" content=\"The article reveals simple steps to enable remote MySQL in domain cPanel interface.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-06T06:36:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-12T12:10:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"445\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/\"},\"author\":{\"name\":\"Pallavi Godse\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"headline\":\"How to Enable Remote MySQL in the Domain cPanel Interface?\",\"datePublished\":\"2018-11-06T06:36:00+00:00\",\"dateModified\":\"2022-02-12T12:10:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/\"},\"wordCount\":223,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png\",\"keywords\":[\"MySQL\",\"MySQL database\",\"remote MySQL\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/\",\"name\":\"Steps to Enable Remote MySQL in Domain cPanel Interface\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png\",\"datePublished\":\"2018-11-06T06:36:00+00:00\",\"dateModified\":\"2022-02-12T12:10:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"The article reveals simple steps to enable remote MySQL in domain cPanel interface.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png\",\"width\":800,\"height\":445},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Enable Remote MySQL in the Domain cPanel Interface?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"sameAs\":[\"https:\/\/www.milesweb.in\"],\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/author\/pallavi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Steps to Enable Remote MySQL in Domain cPanel Interface","description":"The article reveals simple steps to enable remote MySQL in domain cPanel interface.","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:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/","og_locale":"en_US","og_type":"article","og_title":"Steps to Enable Remote MySQL in Domain cPanel Interface","og_description":"The article reveals simple steps to enable remote MySQL in domain cPanel interface.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2018-11-06T06:36:00+00:00","article_modified_time":"2022-02-12T12:10:45+00:00","og_image":[{"width":800,"height":445,"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png","type":"image\/png"}],"author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/"},"author":{"name":"Pallavi Godse","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"headline":"How to Enable Remote MySQL in the Domain cPanel Interface?","datePublished":"2018-11-06T06:36:00+00:00","dateModified":"2022-02-12T12:10:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/"},"wordCount":223,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png","keywords":["MySQL","MySQL database","remote MySQL"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/","name":"Steps to Enable Remote MySQL in Domain cPanel Interface","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png","datePublished":"2018-11-06T06:36:00+00:00","dateModified":"2022-02-12T12:10:45+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"The article reveals simple steps to enable remote MySQL in domain cPanel interface.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2018\/11\/How-to-Enable-Remote-MySQL-in-the-Domain-min.png","width":800,"height":445},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/enable-remote-mysql-in-domain-cpanel-interface\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Enable Remote MySQL in the Domain cPanel Interface?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","sameAs":["https:\/\/www.milesweb.in"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/pallavi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=6001"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6001\/revisions"}],"predecessor-version":[{"id":15755,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6001\/revisions\/15755"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media\/6059"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=6001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=6001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=6001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}