{"id":2529,"date":"2021-08-20T09:02:57","date_gmt":"2021-08-20T14:02:57","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=2529"},"modified":"2022-08-25T08:26:50","modified_gmt":"2022-08-25T13:26:50","slug":"how-to-connect-to-mysql-remotely-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/","title":{"rendered":"How to connect to MySQL Remotely in cPanel?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #212121;color:#212121\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #212121;color:#212121\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#allow_remote_connections\" >Allow Remote Connections<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#connect_to_mysql_remotely\" >Connect To MySQL Remotely<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>If you&#8217;re a developer and want to access the MySQL database remotely from your local system. In that case, cPanel offers Remote MySQL functionality through which you need to allow your IP to get started.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"allow_remote_connections\"><\/span>Allow Remote Connections<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>1. Log in to cPanel using&nbsp;<strong>Username&nbsp;<\/strong>&amp;&nbsp;<strong>Password<\/strong>.&nbsp;i.e;&nbsp;<em>(https:\/\/yourdomain.com:2083 or https:\/\/yourdomain.com\/cpanel)<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png\" alt=\"\" class=\"wp-image-2388\"\/><\/figure>\n\n\n\n<p>2. Navigate to <strong>Databases \u2192 Remote MySQL\u00ae<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"936\" height=\"481\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-remote-mysql-cpanel.jpg\" alt=\"\" class=\"wp-image-2530\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-remote-mysql-cpanel.jpg 936w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-remote-mysql-cpanel-300x154.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-remote-mysql-cpanel-768x395.jpg 768w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/figure>\n\n\n\n<p>3. Provide the following necessary details,<\/p>\n\n\n\n<p><strong>Host<\/strong>: Enter your static network IP. If you don&#8217;t have one, you need to allow connections from all the IPs by putting &#8220;%&#8221; (wild card) in the Host file. For this article, we will be allowing remote connections from all the IP adderesses.<\/p>\n\n\n\n<p><strong>Comment<\/strong><em>(optional)<\/em>: To remember the entry, you can write the statement.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"464\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/add-the-ip-in-remote-mysql-1024x464.jpg\" alt=\"\" class=\"wp-image-2531\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/add-the-ip-in-remote-mysql-1024x464.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/add-the-ip-in-remote-mysql-300x136.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/add-the-ip-in-remote-mysql-768x348.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/add-the-ip-in-remote-mysql.jpg 1061w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>4. &nbsp;To save the configuration <strong>\u2192<\/strong> Click the &#8220;<strong>Add Host<\/strong>&#8221; button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"464\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-add-host-to-allow-ip-in-remote-mysql-1024x464.jpg\" alt=\"\" class=\"wp-image-2532\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-add-host-to-allow-ip-in-remote-mysql-1024x464.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-add-host-to-allow-ip-in-remote-mysql-300x136.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-add-host-to-allow-ip-in-remote-mysql-768x348.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-add-host-to-allow-ip-in-remote-mysql.jpg 1061w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong><em>Note: We recommend you contacting your Host to completely whitelist your static IP in the firewall to avoid further inconsistencies.<\/em><\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"connect_to_mysql_remotely\"><\/span><strong>Connect To MySQL Remotely<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>For the <a href=\"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/\">remote MySQL connections<\/a>, there are many free and commercial applications present in the market. For example: MySQL Workbench, HeidiSQL, etc. In this article, we will continue the RemoteSQL connection with the HeidiSQL application.<\/p>\n\n\n\n<p>1. Download the HeidiSQL application (https:\/\/www.heidisql.com\/) and Open.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"855\" height=\"605\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/heidlisql-window-application.jpg\" alt=\"\" class=\"wp-image-2533\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/heidlisql-window-application.jpg 855w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/heidlisql-window-application-300x212.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/heidlisql-window-application-768x543.jpg 768w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/figure>\n\n\n\n<p>2. Now click on &#8220;<strong>+ NEW<\/strong>&#8221; for Remote MySQL Connection.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"855\" height=\"605\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-new-heidlisql.jpg\" alt=\"\" class=\"wp-image-2534\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-new-heidlisql.jpg 855w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-new-heidlisql-300x212.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/click-on-new-heidlisql-768x543.jpg 768w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/figure>\n\n\n\n<p>3. Next, select Network Type, Library and provide the required information,<\/p>\n\n\n\n<p><strong>Hostname\/IP<\/strong>: Enter the MySQL server IP address or hostname.<\/p>\n\n\n\n<p><strong>User<\/strong>: Enter MySQL username.<\/p>\n\n\n\n<p><strong>Password<\/strong>: Enter a password of your MySQL username.<\/p>\n\n\n\n<p><strong>Port<\/strong>: Enter the Port of MySQL.<\/p>\n\n\n\n<p><strong>Database Name<\/strong>: Enter the MySQL Database name.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"855\" height=\"605\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-all-remote-mysql-connection-information.jpg\" alt=\"\" class=\"wp-image-2535\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-all-remote-mysql-connection-information.jpg 855w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-all-remote-mysql-connection-information-300x212.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-all-remote-mysql-connection-information-768x543.jpg 768w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/figure>\n\n\n\n<p>4. Now click on <strong>Open<\/strong> to initiate a remote connection to the MySQL server.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"855\" height=\"605\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/remote-mysql-click-on-open.jpg\" alt=\"\" class=\"wp-image-2536\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/remote-mysql-click-on-open.jpg 855w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/remote-mysql-click-on-open-300x212.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/remote-mysql-click-on-open-768x543.jpg 768w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that we\u2019ve gone over how to allow remote MySQL connection and how to properly connect to remote MySQL easily with HeidiSQL windows application. You should be able to login to remote MySQL from any location but make sure to allow network in cPanel  <strong>\u2192<\/strong>  Remote MySQL.<\/p>\n\n\n\n<p>KnownHost offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team ready to help you should you need our assistance. You\u2019re not using KnownHost for the best <a href=\"https:\/\/www.knownhost.com\/\"><strong>web hosting<\/strong><\/a> experience? Well, why not? Check with&nbsp;<a href=\"https:\/\/www.knownhost.com\/contact\">our Sales team<\/a>&nbsp;to see what can KnownHost do for you in improving your web hosting experience.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re a developer and want to access the MySQL database remotely from your local system. In that case, cPanel offers Remote MySQL functionality through which you need to allow your IP to get started. Allow Remote Connections 1. Log in to cPanel using&nbsp;Username&nbsp;&amp;&nbsp;Password.&nbsp;i.e;&nbsp;(https:\/\/yourdomain.com:2083 or https:\/\/yourdomain.com\/cpanel) 2. Navigate to Databases \u2192 Remote MySQL\u00ae. 3. Provide [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[359,360,109,186,358],"class_list":["post-2529","post","type-post","status-publish","format-standard","hentry","category-cpanel","tag-allow","tag-connect","tag-cpanel","tag-mysql","tag-remote"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to connect to MySQL Remotely in cPanel? - KnownHost<\/title>\n<meta name=\"description\" content=\"Do you need to connect to your MySQL server? In this guide we will show you how to use cPanel to connect to MySQL database remotely.\" \/>\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.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to connect to MySQL Remotely in cPanel? - KnownHost\" \/>\n<meta property=\"og:description\" content=\"Do you need to connect to your MySQL server? In this guide we will show you how to use cPanel to connect to MySQL database remotely.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-20T14:02:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-25T13:26:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png\" \/>\n<meta name=\"author\" content=\"Somesh Z\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Somesh Z\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/\"},\"author\":{\"name\":\"Somesh Z\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\"},\"headline\":\"How to connect to MySQL Remotely in cPanel?\",\"datePublished\":\"2021-08-20T14:02:57+00:00\",\"dateModified\":\"2022-08-25T13:26:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/\"},\"wordCount\":390,\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Login-to-cpanel-using-user-and-password.png\",\"keywords\":[\"allow\",\"connect\",\"cpanel\",\"mysql\",\"remote\"],\"articleSection\":[\"cPanel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/\",\"name\":\"How to connect to MySQL Remotely in cPanel? - KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Login-to-cpanel-using-user-and-password.png\",\"datePublished\":\"2021-08-20T14:02:57+00:00\",\"dateModified\":\"2022-08-25T13:26:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\"},\"description\":\"Do you need to connect to your MySQL server? In this guide we will show you how to use cPanel to connect to MySQL database remotely.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Login-to-cpanel-using-user-and-password.png\",\"contentUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Login-to-cpanel-using-user-and-password.png\",\"width\":1002,\"height\":829},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-connect-to-mysql-remotely-in-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to connect to MySQL Remotely in cPanel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\",\"name\":\"KnownHost\",\"description\":\"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\",\"name\":\"Somesh Z\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"caption\":\"Somesh Z\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to connect to MySQL Remotely in cPanel? - KnownHost","description":"Do you need to connect to your MySQL server? In this guide we will show you how to use cPanel to connect to MySQL database remotely.","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.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How to connect to MySQL Remotely in cPanel? - KnownHost","og_description":"Do you need to connect to your MySQL server? In this guide we will show you how to use cPanel to connect to MySQL database remotely.","og_url":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/","og_site_name":"KnownHost","article_published_time":"2021-08-20T14:02:57+00:00","article_modified_time":"2022-08-25T13:26:50+00:00","og_image":[{"url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","type":"","width":"","height":""}],"author":"Somesh Z","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Somesh Z","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/"},"author":{"name":"Somesh Z","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1"},"headline":"How to connect to MySQL Remotely in cPanel?","datePublished":"2021-08-20T14:02:57+00:00","dateModified":"2022-08-25T13:26:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/"},"wordCount":390,"image":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","keywords":["allow","connect","cpanel","mysql","remote"],"articleSection":["cPanel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/","url":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/","name":"How to connect to MySQL Remotely in cPanel? - KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","datePublished":"2021-08-20T14:02:57+00:00","dateModified":"2022-08-25T13:26:50+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1"},"description":"Do you need to connect to your MySQL server? In this guide we will show you how to use cPanel to connect to MySQL database remotely.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#primaryimage","url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","contentUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","width":1002,"height":829},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/how-to-connect-to-mysql-remotely-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to connect to MySQL Remotely in cPanel?"}]},{"@type":"WebSite","@id":"https:\/\/www.knownhost.com\/kb\/#website","url":"https:\/\/www.knownhost.com\/kb\/","name":"KnownHost","description":"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knownhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1","name":"Somesh Z","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","caption":"Somesh Z"}}]}},"_links":{"self":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/2529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/comments?post=2529"}],"version-history":[{"count":0,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/2529\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=2529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=2529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=2529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}