{"id":6343,"date":"2018-11-29T14:03:34","date_gmt":"2018-11-29T14:03:34","guid":{"rendered":"https:\/\/www.siliconhouse.net\/support\/?page_id=6343"},"modified":"2018-11-29T14:04:37","modified_gmt":"2018-11-29T14:04:37","slug":"how-to-connect-remote-mysql-connection-in-cpanel-server","status":"publish","type":"page","link":"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/","title":{"rendered":"how to connect remote MySQL connection in cpanel server?"},"content":{"rendered":"<div class=\"dedicated_server_hosting_features_center\">\n<div class=\"reseller_web_hosting_support_navigation\"><aside id=\"bcn_widget-2\" class=\"widget widget_breadcrumb_navxt amr_widget\"><span property=\"itemListElement\" typeof=\"ListItem\"><a property=\"item\" typeof=\"WebPage\" title=\"Go to Silicon House - Reseller Hosting - Dedicated Servers - Cloud.\" href=\"https:\/\/www.siliconhouse.net\/support\" class=\"home\"><span property=\"name\" style=\"color: #232323\"><b>Support Home<\/b><\/span><\/a><meta property=\"position\" content=\"1\"><\/span><\/aside><\/div>\n<div class=\"dedicated_server_hosting_features\">\n<p>Silicon House provides <a href=\"https:\/\/www.siliconhouse.net\/dedicated-servers-managed\">fully managed linux dedicated server<\/a> with the cheapest cost. There may be times when you have to connect to the database from outside your work network and if that&#8217;s the case, you need to connect to your database using third party software that does not run on the server (i.e. a MySQL client on your desktop) or also called as\u00a0 remote MySQL. First you have to allow the connection from within cPanel for the IP address you are connecting from. Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server.When remote host access is enabled, you can use remote client applications to connect to your databases directly.<\/p>\n<p><aside id=\"text-16\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><div class=\"reseller_web_hosting_support_advts\">\r\n\r\n<div class=\"reseller_web_hosting_support_advts_left\">\r\n<a href=\"https:\/\/www.siliconhouse.net\/linux-reseller-web-hosting-india\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"https:\/\/www.siliconhouse.net\/wp-content\/uploads\/2018\/06\/336X280-saffron-unlimited-499-kickstart.gif\" width=\"336\" height=\"280\" alt=\"Reseller Hosting Special Offer\"><\/a>\r\n<\/div>\r\n\r\n<div class=\"reseller_web_hosting_support_advts_right\">\r\n<a href=\"https:\/\/www.siliconhouse.net\/linux-cloud-server-hosting-india\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"https:\/\/www.siliconhouse.net\/wp-content\/uploads\/2018\/06\/336X280-purple-enterprise-cloud-stak-19.jpg\" width=\"336\" height=\"280\" alt=\"Enterprise Cloud Stack\"><\/a>\r\n<\/div>\r\n\r\n<\/div><\/div>\n\t\t<\/aside><br \/>\n<aside id=\"text-20\" class=\"extendedwopts-md-center widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><div class=\"reseller_web_hosting_support_advts\">\r\n<div class=\"reseller_web_hosting_support_advts_left\">\r\n<img decoding=\"async\" border=\"0\" src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/reseller-hosting-249-offer.gif\" width=\"320\" height=\"100\" alt=\"Reseller Hosting Special Offer\">\r\n<\/div>\r\n\r\n<div class=\"reseller_web_hosting_support_advts_right\">\r\n<img decoding=\"async\" border=\"0\" src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/reseller-hosting-249-offer.gif\" width=\"320\" height=\"100\" alt=\"Reseller Hosting Special Offer\">\r\n<\/div>\r\n\r\n<\/div><\/div>\n\t\t<\/aside><\/p>\n<div class=\"dedicated_server_hosting_features\">\n<p>Adding an IP address to allow a remote MySQL connection<\/p>\n<p>1.Log into cPanel<\/p>\n<p>2.Click the Remote MySQL button in the Databases section.<\/p>\n<p>3.Enter the remote IP address in the Add Access Host section<\/p>\n<p>Note : If you are connecting to a database from your current connection, then you get your IP address by clicking getmyip.co.in<\/p>\n<p>IP address can be IPv4 address, or an IPv6 address<\/p>\n<p>you may use the percentage sign character (%) as a wildcard. For example, to allow access from all IP addresses that begin with 10.0.0, enter 10.0.0.%.<\/p>\n<p>4.Enter a description for the remote host in the Comment text box<\/p>\n<p>Note : This is optional<\/p>\n<p>5.Click the Add Host button<\/p>\n<p>6.You will then see a message stating the host IP address was added to the access list<\/p>\n<p>Note that if you want to add many ip address to access the database you can add here by using the above procedure.<\/p>\n<p>Delete an access host<\/p>\n<p>1.Log into cPanel<\/p>\n<p>2.Click the Remote MySQL button in the Databases section.<\/p>\n<p>3.Click Delete next to the host\u2019s name or IP address. A confirmation message will appear.<\/p>\n<p>4.Click Remove Access Host. A message of success will appear.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Silicon House provides fully managed linux dedicated server with the cheapest cost. There may be times when you have to<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":27,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-6343","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>how to connect remote MySQL connection in cpanel server?<\/title>\n<meta name=\"description\" content=\"Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server\" \/>\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.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"how to connect remote MySQL connection in cpanel server?\" \/>\n<meta property=\"og:description\" content=\"Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/siliconhouse.net\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-29T14:04:37+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@siliconhouse\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/\",\"name\":\"how to connect remote MySQL connection in cpanel server?\",\"isPartOf\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#website\"},\"datePublished\":\"2018-11-29T14:03:34+00:00\",\"dateModified\":\"2018-11-29T14:04:37+00:00\",\"description\":\"Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server\",\"breadcrumb\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.siliconhouse.net\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dedicated Servers\",\"item\":\"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Linux Dedicated Server Hosting\",\"item\":\"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"how to connect remote MySQL connection in cpanel server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#website\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/\",\"name\":\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\",\"description\":\"Reseller Hosting - Dedicated Servers - Cloud\",\"publisher\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.siliconhouse.net\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#organization\",\"name\":\"Silicon House\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png\",\"contentUrl\":\"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png\",\"width\":42,\"height\":40,\"caption\":\"Silicon House\"},\"image\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/siliconhouse.net\",\"https:\/\/x.com\/siliconhouse\",\"https:\/\/www.youtube.com\/siliconhouse\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"how to connect remote MySQL connection in cpanel server?","description":"Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server","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.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/","og_locale":"en_US","og_type":"article","og_title":"how to connect remote MySQL connection in cpanel server?","og_description":"Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server","og_url":"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/","og_site_name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","article_publisher":"https:\/\/www.facebook.com\/siliconhouse.net","article_modified_time":"2018-11-29T14:04:37+00:00","twitter_card":"summary_large_image","twitter_site":"@siliconhouse","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/","url":"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/","name":"how to connect remote MySQL connection in cpanel server?","isPartOf":{"@id":"https:\/\/www.siliconhouse.net\/support\/#website"},"datePublished":"2018-11-29T14:03:34+00:00","dateModified":"2018-11-29T14:04:37+00:00","description":"Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server","breadcrumb":{"@id":"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/how-to-connect-remote-mysql-connection-in-cpanel-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.siliconhouse.net\/support\/"},{"@type":"ListItem","position":2,"name":"Dedicated Servers","item":"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/"},{"@type":"ListItem","position":3,"name":"Linux Dedicated Server Hosting","item":"https:\/\/www.siliconhouse.net\/support\/dedicated-servers\/linux-dedicated-server-hosting\/"},{"@type":"ListItem","position":4,"name":"how to connect remote MySQL connection in cpanel server?"}]},{"@type":"WebSite","@id":"https:\/\/www.siliconhouse.net\/support\/#website","url":"https:\/\/www.siliconhouse.net\/support\/","name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","description":"Reseller Hosting - Dedicated Servers - Cloud","publisher":{"@id":"https:\/\/www.siliconhouse.net\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.siliconhouse.net\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.siliconhouse.net\/support\/#organization","name":"Silicon House","url":"https:\/\/www.siliconhouse.net\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","contentUrl":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","width":42,"height":40,"caption":"Silicon House"},"image":{"@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/siliconhouse.net","https:\/\/x.com\/siliconhouse","https:\/\/www.youtube.com\/siliconhouse"]}]}},"_links":{"self":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/comments?post=6343"}],"version-history":[{"count":1,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6343\/revisions"}],"predecessor-version":[{"id":6344,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6343\/revisions\/6344"}],"up":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/27"}],"wp:attachment":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/media?parent=6343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}