{"id":341,"date":"2011-12-14T16:43:23","date_gmt":"2011-12-14T16:43:23","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2011\/12\/14\/setting-up-a-remote-mysql-connection-in-cpanel\/"},"modified":"2026-01-22T09:31:40","modified_gmt":"2026-01-22T14:31:40","slug":"setting-up-a-remote-mysql-connection-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/","title":{"rendered":"Setting up a Remote MySQL Database Connection"},"content":{"rendered":"<div class=\"imh-youtube-embed\">\n\t\t\t<iframe src=\"https:\/\/www.youtube.com\/embed\/h_kNQOd_n-U\" title=\"Setting up a Remote MySQL Database Connection\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\t\t\t<script type=\"application\/ld+json\">{\"@context\":\"https:\/\/schema.org\",\"@type\":\"VideoObject\",\"name\":\"Setting up a Remote MySQL Database Connection\",\"description\":\"Learn how to allow a remote MySQL connection by adding the IP to your firewall in cPanel.\",\"uploadDate\":\"2016-10-21\",\"thumbnailUrl\":\"https:\/\/img.youtube.com\/vi\/h_kNQOd_n-U\/hqdefault.jpg\"}<\/script>\n\t\t<\/div>\n\n\n\n<p>Selecting a reputable web hosting company is only the first step towards building and maintaining a successful website. There may be times when you have to connect to the database from outside your work network and if that\u2019s 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). This is referred to as making a remote MySQL connection. To do this, however, you will first have to allow the connection from within cPanel for the IP address you are connecting from. Read on to learn how.<\/p>\n\n\n\n<p><a name=\"program\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"program-to-use\">What program do I use to connect remotely?<\/h2>\n\n\n\n<p>There are a few programs you can use to connect remotely to your database. You can utilize HTML editors like Adobe Dreamweaver for a fee, or there are free Open Source programs you can use like MySQL Workbench or Heidi SQL. Here are some options to check out.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"\/support\/server\/databases\/connect-database-navicat\/\" target=\"_blank\" rel=\"noopener noreferrer\">Navicat for MySQL<\/a><\/li>\n\n\n\n<li><a href=\"\/support\/website\/connect-database-remotely-mysql-workbench\/\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL Workbench<\/a><\/li>\n\n\n\n<li><a href=\"\/support\/server\/databases\/connecting-heidi-sql-database\/\" target=\"_blank\" rel=\"noopener noreferrer\">Heidi SQL<\/a><\/li>\n<\/ul>\n\n\n\n<p><a name=\"add-ip\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"add-ip\">Adding an IP address to allow a remote MySQL connection<\/h2>\n\n\n\n<p>First, you will need to make sure you have the IP address that will be accessing the database. These rules protect the database by only accepting external connections that you have set up. If you are connecting to a database from your current connection, get your IP address by clicking<a href=\"https:\/\/www.inmotionhosting.com\/ip\" target=\"_blank\" rel=\"noopener noreferrer\"> here<\/a>, then follow these steps:<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li><a href=\"\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\">Log into cPanel<\/a>.<\/li>\n\n\n\n<li>Click the <strong>Remote MySQL<\/strong> button in the <em>Databases<\/em> section.<br><figure><a href=\"\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png\" rel=\"lightbox-0\"><img decoding=\"async\" width=\"500\" height=\"400\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png\" class=\"optimized-lcp-image\" alt=\"\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png 500w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02-300x240.png 300w\"><\/a><\/figure><br><p>\u00a0<\/p><br><div style=\"clear: both;\">\u00a0<\/div><br><\/li>\n\n\n\n<li>Enter the remote IP address in the <em>Add Access Host<\/em> section.<br><figure><a href=\"\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_03.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"357\" class=\"std_ss size-full wp-image-5378\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_03.png\" alt=\"\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_03.png 487w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_03-300x220.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/a><\/figure><br><p>\u00a0<\/p><br><div style=\"clear: both;\">\u00a0<\/div><br><\/li>\n\n\n\n<li>Click the <strong>Add Host<\/strong> button.<br><figure><a href=\"\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_04.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" width=\"507\" height=\"225\" class=\"std_ss size-full wp-image-5379\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_04.png\" alt=\"\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_04.png 507w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_04-300x133.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/a><\/figure><br><p>\u00a0<\/p><br><div style=\"clear: both;\">\u00a0<\/div><br><p>You will then see a message stating the host IP address was added to the access list.<br><a href=\"\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_05.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" width=\"581\" height=\"390\" class=\"std_ss size-full wp-image-5380\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_05.png\" alt=\"\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_05.png 581w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_05-300x201.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/a><\/p><br><div style=\"clear: both;\">\u00a0<\/div><br><\/li>\n<\/ol>\n\n\n\n<p>Now, since you have added the IP address to remote MySQL connections you will be able to connect to the databases. You can add as many IP addresses as you need.<\/p>\n\n\n\n<p><a name=\"wildcard\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"use-wildcard\">Using a Wildcard to allow all IP\u2019s<\/h2>\n\n\n\n<p>You may find you need to use a wildcard if your IP address changes regularly. You can add a wildcard by using the <strong>% symbol<\/strong>. This will add all IP addresses in that range.<\/p>\n\n\n\n<p>For example, if you want to list all IP addresses in the range 174.77.92.1 to 174.77.92.255 you\u2019d add the IP address 174.77.92.%.<\/p>\n\n\n\n<p><a name=\"troubleshoot\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"troubleshooting\">Troubleshooting Remote connection issues<\/h2>\n\n\n\n<p>If you are using your preferred remote connection tool and suddenly it will not connect, it\u2019s known as a <em>1045 error<\/em> and usually reads similar to \u2018<strong>1045 \u2013 access denied for user<\/strong>\u2018. If you are getting this error, here are a couple of things to check:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Check your cPanel password<\/h3>\n\n\n\n<p>Many people connect remotely using their <a href=\"\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\">cPanel username and password<\/a> as opposed to <a href=\"\/support\/edu\/cpanel\/create-database-user\/\">creating a single administrative user<\/a> to add to the databases. This is not the preferred method, however, if you do use the cPanel username and you are now getting a connection error, chances are you recently changed the <a href=\"\/support\/edu\/cpanel\/change-cpanel-password\/\">cPanel password<\/a> and have not changed it in the Remote connection software settings. Change the password there and you should be able to connect once again.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Check to see if connecting IP has changed<\/h3>\n\n\n\n<p>From time to time your ISP (Internet Service Provider) may change your public IP address. If that is the case, you may find yourself unable to connect remotely via your <a href=\"\/support\/website\/security\/password-strength\/#program\">preferred software<\/a>. Check your IP address by clicking <a href=\"https:\/\/support.inmotionhosting.com\/ipcheck.php\">here<\/a>.<\/p>\n\n\n\n<p>Once you know your current IP address, go back and make sure that it is in the list of allowed IP addresses for your <em>Remote MySQL<\/em> settings. If you find it was not in the list, add the new one and then you should then be able to connect remotely.<\/p>\n\n\n\n<p>If you need further assistance with connecting to a database remotely please <a href=\"\/support\/amp\/how-to-get-great-technical-support\/\">contact our support department<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Selecting a reputable web hosting company is only the first step towards building and maintaining a successful website. 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<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\"> Read More ><\/a><\/p>\n","protected":false},"author":56983,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4288,4305],"tags":[],"class_list":["post-341","post","type-post","status-publish","format-standard","hentry","category-website","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Setting up a Remote MySQL Database Connection<\/title>\n<meta name=\"description\" content=\"Learn how to set up a remote MySQL connection within your cPanel so you can connect and work with your databases 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.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting up a Remote MySQL Database Connection\" \/>\n<meta property=\"og:description\" content=\"Learn how to set up a remote MySQL connection within your cPanel so you can connect and work with your databases remotely.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2011-12-14T16:43:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-22T14:31:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Carrie Smaha\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@carriesmaha\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Carrie Smaha\" \/>\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.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\"},\"author\":{\"name\":\"Carrie Smaha\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8\"},\"headline\":\"Setting up a Remote MySQL Database Connection\",\"datePublished\":\"2011-12-14T16:43:23+00:00\",\"dateModified\":\"2026-01-22T14:31:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\"},\"wordCount\":663,\"commentCount\":62,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png\",\"articleSection\":[\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\",\"name\":\"Setting up a Remote MySQL Database Connection\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png\",\"datePublished\":\"2011-12-14T16:43:23+00:00\",\"dateModified\":\"2026-01-22T14:31:40+00:00\",\"description\":\"Learn how to set up a remote MySQL connection within your cPanel so you can connect and work with your databases remotely.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png\",\"width\":500,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting up a Remote MySQL Database Connection\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8\",\"name\":\"Carrie Smaha\",\"description\":\"Carrie Smaha is a Senior Marketing Operations leader with over 20 years of experience in digital strategy, web development, and IT project management. She specializes in go-to-market programs and SaaS solutions for WordPress and VPS Hosting, working closely with technical teams and customers to deliver high-performance, scalable platforms. At InMotion Hosting, she drives product marketing initiatives that blend strategic insight with technical depth.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/carriesmaha\/\",\"https:\/\/x.com\/carriesmaha\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/carries\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting up a Remote MySQL Database Connection","description":"Learn how to set up a remote MySQL connection within your cPanel so you can connect and work with your databases 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.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"Setting up a Remote MySQL Database Connection","og_description":"Learn how to set up a remote MySQL connection within your cPanel so you can connect and work with your databases remotely.","og_url":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2011-12-14T16:43:23+00:00","article_modified_time":"2026-01-22T14:31:40+00:00","og_image":[{"width":500,"height":400,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png","type":"image\/png"}],"author":"Carrie Smaha","twitter_card":"summary_large_image","twitter_creator":"@carriesmaha","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Carrie Smaha","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/"},"author":{"name":"Carrie Smaha","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8"},"headline":"Setting up a Remote MySQL Database Connection","datePublished":"2011-12-14T16:43:23+00:00","dateModified":"2026-01-22T14:31:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/"},"wordCount":663,"commentCount":62,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png","articleSection":["Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/","url":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/","name":"Setting up a Remote MySQL Database Connection","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png","datePublished":"2011-12-14T16:43:23+00:00","dateModified":"2026-01-22T14:31:40+00:00","description":"Learn how to set up a remote MySQL connection within your cPanel so you can connect and work with your databases remotely.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2011\/12\/newPaperLantern_cmNewPaper_02.png","width":500,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Setting up a Remote MySQL Database Connection"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8","name":"Carrie Smaha","description":"Carrie Smaha is a Senior Marketing Operations leader with over 20 years of experience in digital strategy, web development, and IT project management. She specializes in go-to-market programs and SaaS solutions for WordPress and VPS Hosting, working closely with technical teams and customers to deliver high-performance, scalable platforms. At InMotion Hosting, she drives product marketing initiatives that blend strategic insight with technical depth.","sameAs":["https:\/\/www.linkedin.com\/in\/carriesmaha\/","https:\/\/x.com\/carriesmaha"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/carries\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4288,"name":"Website","slug":"website","link":"https:\/\/www.inmotionhosting.com\/support\/website\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/341","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/56983"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=341"}],"version-history":[{"count":11,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/341\/revisions"}],"predecessor-version":[{"id":131460,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/341\/revisions\/131460"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=341"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=341"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}