{"id":6138,"date":"2019-07-24T06:30:14","date_gmt":"2019-07-24T06:30:14","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=6138"},"modified":"2019-07-24T06:30:14","modified_gmt":"2019-07-24T06:30:14","slug":"learn-to-configure-remote-mysql-access-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/","title":{"rendered":"Learn to configure Remote MySQL access in cPanel"},"content":{"rendered":"<p>This article explains how to use cPanel to allow external hosts to access your MySQL databases. You can use remote client applications to connect to your databases directly simply when remote host access is enabled.<\/p>\n<h2># Steps to add host access<\/h2>\n<p>1. Log in to cPanel.<\/p>\n<p>2. On the cPanel home screen in the Databases section, click on Remote MySQL.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6139 size-full\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png\" alt=\"Remote SQL\" width=\"198\" height=\"62\" \/><\/a><\/p>\n<p>3. Under the Add Access Host, in the Host text box, type the domain name or IP address of the host that you want to add.<\/p>\n<p><strong>Note:<\/strong> You can find your IP address by entering a query &#8216;What is my IP &#8216; in search engine.<\/p>\n<p>4. In the text box for Comment, you may add a comment to describe the remote host. This is optional.<\/p>\n<p>5. Click on Add Host.<\/p>\n<h2># Access your database remotely<\/h2>\n<p>After enabling host access, you can connect to your MySQL databases remotely by using MySQL client application.<\/p>\n<h2># Steps to remove host access<\/h2>\n<p>When you don&#8217;t want a host to access you MySQL databases remotely, you can remove them by performing following steps :<\/p>\n<p>1. Log in to cPanel.<\/p>\n<p>2. On the cPanel home screen in the Databases section, click on Remote MySQL.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-2-min.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6140 size-full\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-2-min.png\" alt=\"Remote SQL 2\" width=\"198\" height=\"62\" \/><\/a><\/p>\n<p>3. Under the Manage Access Hosts option, identify the host for which you want to remove the access, and then click on Delete.<\/p>\n<p>4. Click on Remote Access Host. cPanel will remove the host.<\/p>\n<p><strong>Also Read :<\/strong><\/p>\n<p><strong>1)<a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-search-mysql-tables-in-phpmyadmin\/\">How to search MySQL tables in phpMyAdmin?<\/a><\/strong><\/p>\n<p><strong>2)\u00a0<a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-check-a-mysql-database-for-errors-in-cpanel\/\">How Can I Check a MySQL Database for Errors in cPanel?<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article explains how to use cPanel to allow external hosts to access your MySQL databases. You can use remote client applications to connect to your databases directly simply when remote host access is enabled. # Steps to add host access 1. Log in to cPanel. 2. On the cPanel home screen in the Databases [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[152,205,538],"class_list":["post-6138","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq","tag-cpanel","tag-mysql","tag-remote-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Learn to configure Remote MySQL access in cPanel - Web Hosting FAQs by MilesWeb<\/title>\n<meta name=\"description\" content=\"Easy steps to configure remote MySQL access in cPanel.\" \/>\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.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn to configure Remote MySQL access in cPanel - Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"og:description\" content=\"Easy steps to configure remote MySQL access in cPanel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-24T06:30:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png\" \/>\n<meta name=\"author\" content=\"Sonam Wagh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sonam Wagh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/\",\"name\":\"Learn to configure Remote MySQL access in cPanel - Web Hosting FAQs by MilesWeb\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png\",\"datePublished\":\"2019-07-24T06:30:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\"},\"description\":\"Easy steps to configure remote MySQL access in cPanel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn to configure Remote MySQL access in cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\",\"name\":\"Sonam Wagh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"caption\":\"Sonam Wagh\"},\"description\":\"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn to configure Remote MySQL access in cPanel - Web Hosting FAQs by MilesWeb","description":"Easy steps to configure remote MySQL access in 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:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/","og_locale":"en_GB","og_type":"article","og_title":"Learn to configure Remote MySQL access in cPanel - Web Hosting FAQs by MilesWeb","og_description":"Easy steps to configure remote MySQL access in cPanel.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-07-24T06:30:14+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png","type":"","width":"","height":""}],"author":"Sonam Wagh","twitter_misc":{"Written by":"Sonam Wagh","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/","name":"Learn to configure Remote MySQL access in cPanel - Web Hosting FAQs by MilesWeb","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png","datePublished":"2019-07-24T06:30:14+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4"},"description":"Easy steps to configure remote MySQL access in cPanel.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/07\/Remote-sql-min.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-configure-remote-mysql-access-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Learn to configure Remote MySQL access in cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4","name":"Sonam Wagh","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","caption":"Sonam Wagh"},"description":"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/"}]}},"views":644,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=6138"}],"version-history":[{"count":1,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6138\/revisions"}],"predecessor-version":[{"id":6141,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6138\/revisions\/6141"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=6138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=6138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=6138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}