{"id":34908,"date":"2026-07-10T11:30:34","date_gmt":"2026-07-10T11:30:34","guid":{"rendered":"https:\/\/1grid.co.za\/knowledge\/?post_type=ht_kb&#038;p=34908"},"modified":"2026-07-10T11:30:35","modified_gmt":"2026-07-10T11:30:35","slug":"remote-mysql-access-how-to-configure-on-1-grid-hosting","status":"publish","type":"ht_kb","link":"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/","title":{"rendered":"Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Databases\u00a0contain\u00a0critical website information, which means that remote MySQL access is restricted by default to help protect your data.\u00a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This guide will help you configure Remote MySQL access for your hosting account, allowing approved external applications, servers, or development tools to connect securely to your database.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By the end of this guide,&nbsp;you&#8217;ll&nbsp;understand when Remote MySQL access should be used, how to configure it safely, and how to verify that your connection is working correctly.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"600\" src=\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2026\/07\/1-grid-Images-for-KB-Articles-1000-x-600-px-56.png\" alt=\"How to Configure Remote MySQL Access on 1-grid Hosting \" class=\"wp-image-34911\"\/><\/figure>\n<\/div>\n\n\n<div class=\"wp-block-ht-block-toc is-style-rounded htoc htoc--position-wide toc-list-style-plain\" data-htoc-state=\"expanded\"><span class=\"htoc__title\"><span class=\"ht_toc_title\">Quick Links<\/span><span class=\"htoc__toggle\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"16\" height=\"16\"><g fill=\"#444\"><path d=\"M15 7H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1z\"><\/path><path d=\"M15 1H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1zM15 13H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1z\"><\/path><\/g><\/svg><\/span><\/span><div class=\"htoc__itemswrap\"><ul class=\"ht_toc_list\"><li class=\"\"><a href=\"#htoc-step-by-step-instructions-to-configure-remote-access\">Step-by-Step Instructions\u00a0to Configure Remote Access<\/a><\/li><\/ul><\/div><\/div>\n\n\n\n<h2 id=\"htoc-what-this-means\" class=\"wp-block-heading\"><strong>What This Means<\/strong>&nbsp;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Remote MySQL access allows a database hosted on your 1-grid hosting account to accept connections from a server, application, or device&nbsp;located&nbsp;outside your hosting environment.&nbsp;<\/p>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>Common Uses<\/strong><\/summary>\n<ul class=\"wp-block-list\">\n<li>Running applications on another server.&nbsp;<\/li>\n\n\n\n<li>Connecting development tools to a live database.&nbsp;<\/li>\n\n\n\n<li>Integrating third-party software.&nbsp;<\/li>\n\n\n\n<li>Managing databases remotely.&nbsp;<\/li>\n<\/ul>\n<\/details>\n\n\n\n<ul class=\"wp-block-list\"><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Most websites do not require Remote MySQL access because their website and database\u00a0operate\u00a0on the same hosting environment.\u00a0<\/p>\n\n\n\n<h2 id=\"htoc-step-by-step-instructions-to-configure-remote-access\" class=\"wp-block-heading\"><strong>Step-by-Step Instructions\u00a0to Configure Remote Access<\/strong><\/h2>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>1: Confirm That You Need Remote MySQL Access\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-before-enabling-remote-access-verify-that\">Before enabling remote access, verify that:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Your application is hosted on a different server.&nbsp;<\/li>\n\n\n\n<li>A third-party service requires direct database access.&nbsp;<\/li>\n\n\n\n<li>You need to manage the database remotely.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"htoc-if-your-website-and-database-are-hosted-together-remote-mysql-access-is-usually-unnecessary\">If your website and database are hosted together, Remote MySQL access is usually unnecessary.&nbsp;<\/p>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>2:\u00a0Determine\u00a0Which Hosting Platform You Use\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-1-grid-currently-sells-and-supports-plesk-hosting\">1-grid currently sells and supports Plesk Hosting.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"htoc-however-some-legacy-customers-may-still-use-cpanel-hosting\">However, some legacy customers may still use cPanel Hosting.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"htoc-your-configuration-process-will-depend-on-your-hosting-platform\">Your configuration process will depend on your hosting platform.&nbsp;<\/p>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>3:\u00a0Locate\u00a0the IP Address That Requires Access\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-identify-the-public-ip-address-of\">Identify&nbsp;the public IP address of:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The external server.&nbsp;<\/li>\n\n\n\n<li>Development environment.&nbsp;<\/li>\n\n\n\n<li>Third-party application.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"htoc-you-will-need-this-ip-address-when-creating-an-allowlist-entry\">You will need this IP address when creating an allowlist entry.&nbsp;<\/p>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>4: Configure Remote Access\u00a0<\/strong><\/summary>\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>For Legacy cPanel Hosting Accounts\u00a0<\/strong><\/summary>\n<ol start=\"1\" class=\"wp-block-list\">\n<li id=\"htoc-log-in-to-your-1-grid-customer-zone\">Log in to your <a href=\"https:\/\/1grid.co.za\/knowledge\/how-to-log-in-to-cpanel-via-your-1-grid-customer-zone\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>1-grid Customer Zone<\/strong><\/a>.\u00a0<\/li>\n\n\n\n<li id=\"htoc-open-your-hosting-service\">Open your hosting service.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-launch-cpanel\">Launch cPanel.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-navigate-to-databases\">Navigate to&nbsp;<strong>Databases<\/strong>.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-select-remote-mysql-or-remote-database-access\">Select&nbsp;<strong>Remote MySQL\u00ae<\/strong>&nbsp;or&nbsp;<strong>Remote Database Access<\/strong>.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-enter-the-remote-server-ip-address\">Enter the remote server IP address.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-click-add-host\">Click&nbsp;<strong>Add Host<\/strong>.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-ensure-the-correct-database-user-has-appropriate-privileges-assigned\">Ensure the correct database user has&nbsp;appropriate privileges&nbsp;assigned.&nbsp;<\/li>\n<\/ol>\n<\/details>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"7\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"8\" class=\"wp-block-list\"><\/ol>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>For Plesk Hosting Accounts\u00a0<\/strong><\/summary>\n<ol start=\"1\" class=\"wp-block-list\">\n<li id=\"htoc-log-in-to-plesk-via-your-1-grid-customer-zone\">Log in to Plesk via your <a href=\"https:\/\/1grid.co.za\/knowledge\/plesk-how-do-i-login-via-customer-zone\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>1-grid Customer Zone<\/strong><\/a>.\u00a0<\/li>\n\n\n\n<li id=\"htoc-open-databases\">Open&nbsp;<strong>Databases<\/strong>.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-select-the-database-you-wish-to-access\">Select the database you wish to access.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-verify-that-remote-access-is-permitted-for-your-hosting-environment\">Verify that remote access is&nbsp;permitted&nbsp;for your hosting environment.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-use-the-database-connection-details-supplied-within-plesk\">Use the database connection details supplied within Plesk.&nbsp;<\/li>\n\n\n\n<li id=\"htoc-if-restrictions-apply-contact-support-for-assistance-with-your-specific-hosting-configuration\">If restrictions apply, contact Support for&nbsp;assistance&nbsp;with your specific hosting configuration.&nbsp;<\/li>\n<\/ol>\n<\/details>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\"><\/ol>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>5: Verify Firewall Access\u00a0<\/strong><\/summary>\n<ol start=\"2\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"7\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"8\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\"><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"htoc-\">If you manage the remote server:\u00a0<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ensure outbound connections on port 3306 are&nbsp;permitted.&nbsp;<\/li>\n\n\n\n<li>Verify that local&nbsp;firewall&nbsp;rules are not blocking access.&nbsp;<\/li>\n\n\n\n<li>Confirm your hosting environment&nbsp;permits&nbsp;external database connections.&nbsp;<\/li>\n<\/ul>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>6: Test the Connection\u00a0<\/strong><\/summary>\n<ol start=\"2\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"7\" class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\"><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"htoc-1\">Use your preferred database client or application and confirm:\u00a0<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hostname is correct.&nbsp;<\/li>\n\n\n\n<li>Database name is correct.&nbsp;<\/li>\n\n\n\n<li>Username is correct.&nbsp;<\/li>\n\n\n\n<li>Password is correct.&nbsp;<\/li>\n\n\n\n<li>Remote IP is allowlisted.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"htoc-11\">Successful connection confirms your configuration is complete.\u00a0<\/p>\n<\/details>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\"><\/ol>\n\n\n\n<h2 id=\"htoc-important-things-to-know\" class=\"wp-block-heading\"><strong>Important Things to Know<\/strong>&nbsp;<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li id=\"htoc-remote-database-access-is-disabled-by-default-for-security-reasons\">Remote database access is disabled by default for security reasons.\u00a0<\/li>\n\n\n\n<li id=\"htoc-opening-access-to-all-ip-addresses-is-not-recommended\">Opening access to all IP addresses is not recommended.\u00a0<\/li>\n\n\n\n<li id=\"htoc-ip-allowlisting-and-database-permissions-are-separate-requirements\">IP allowlisting and database permissions are separate requirements.\u00a0<\/li>\n\n\n\n<li id=\"htoc-database-credentials-alone-do-not-grant-remote-access\">Database credentials alone do not grant remote access.\u00a0<\/li>\n\n\n\n<li id=\"htoc-some-third-party-applications-may-require-additional-firewall-configuration\">Some third-party applications may require\u00a0additional\u00a0<strong><a href=\"https:\/\/www.fortinet.com\/resources\/cyberglossary\/firewall\">firewall<\/a>\u00a0<\/strong>configuration.\u00a0<\/li>\n\n\n\n<li id=\"htoc-dynamic-ip-addresses-may-require-periodic-updates\">Dynamic IP addresses may require periodic updates.\u00a0<\/li>\n<\/ul>\n\n\n\n<h2 id=\"htoc-before-you-move-on\" class=\"wp-block-heading\"><strong>Before You Move On<\/strong>&nbsp;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before using your remote connection:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li id=\"htoc-verify-the-correct-ip-address-has-been-allowlisted\">Verify the correct IP address has been allowlisted.\u00a0<\/li>\n\n\n\n<li id=\"htoc-confirm-database-user-permissions\">Confirm database user permissions.\u00a0<\/li>\n\n\n\n<li id=\"htoc-test-connectivity-from-the-remote-location\">Test connectivity from the remote location.\u00a0<\/li>\n\n\n\n<li id=\"htoc-remove-any-unused-allowlist-entries\">Remove any unused allowlist entries.\u00a0<\/li>\n\n\n\n<li id=\"htoc-review-firewall-settings\">Review\u00a0firewall\u00a0settings.\u00a0<\/li>\n<\/ul>\n\n\n\n<h2 id=\"htoc-common-mistakes-to-avoid\" class=\"wp-block-heading\"><strong>Common Mistakes to Avoid<\/strong>&nbsp;<\/h2>\n\n\n\n<ul start=\"1\" class=\"wp-block-list\">\n<li id=\"htoc-allowlisting-the-wrong-ip-address\">Allowlisting the wrong IP address.\u00a0<\/li>\n\n\n\n<li id=\"htoc-using-incorrect-database-credentials\">Using incorrect database credentials.\u00a0<\/li>\n\n\n\n<li id=\"htoc-assuming-database-user-permissions-automatically-enable-remote-access\">Assuming database user permissions automatically enable remote access.\u00a0<\/li>\n\n\n\n<li id=\"htoc-allowing-all-ip-addresses-using-unnecessarily\">Allowing all IP addresses using &#8220;%&#8221; unnecessarily.\u00a0<\/li>\n\n\n\n<li id=\"htoc-forgetting-to-open-port-3306-on-the-remote-server\">Forgetting to open port 3306 on the remote server.\u00a0<\/li>\n<\/ul>\n\n\n\n<ul start=\"2\" class=\"wp-block-list\"><\/ul>\n\n\n\n<ul start=\"3\" class=\"wp-block-list\"><\/ul>\n\n\n\n<ul start=\"4\" class=\"wp-block-list\"><\/ul>\n\n\n\n<ul start=\"5\" class=\"wp-block-list\"><\/ul>\n\n\n\n<h2 id=\"htoc-if-this-didn-t-work\" class=\"wp-block-heading\"><strong>If This Didn&#8217;t Work<\/strong>&nbsp;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before contacting Support, collect:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li id=\"htoc-domain-name\">Domain name.\u00a0<\/li>\n\n\n\n<li id=\"htoc-hosting-platform-plesk-or-cpanel\">Hosting platform (Plesk or cPanel).\u00a0<\/li>\n\n\n\n<li id=\"htoc-database-name\">Database name.\u00a0<\/li>\n\n\n\n<li id=\"htoc-database-username\">Database username.\u00a0<\/li>\n\n\n\n<li id=\"htoc-remote-ip-address\">Remote IP address.\u00a0<\/li>\n\n\n\n<li id=\"htoc-exact-error-message\">Exact error message.\u00a0<\/li>\n\n\n\n<li id=\"htoc-screenshot-of-the-error\">Screenshot of the error.\u00a0<\/li>\n\n\n\n<li id=\"htoc-details-of-the-application-attempting-to-connect\">Details of the application\u00a0attempting\u00a0to connect.\u00a0<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This information helps us investigate more efficiently.\u00a0<\/p>\n\n\n\n<h2 id=\"htoc-related-articles\" class=\"wp-block-heading\"><strong>Related Articles<\/strong>&nbsp;<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li id=\"htoc-how-to-create-a-mysql-database-in-plesk\"><a href=\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-create-new-databases\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Create a MySQL Database in Plesk\u00a0<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-how-to-create-a-mysql-database-in-cpanel\"><a href=\"https:\/\/1grid.co.za\/knowledge\/how-to-create-a-mysql-database-in-cpanel\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Create a MySQL Database in cPanel\u00a0<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-what-databases-does-1-grid-support\"><a href=\"https:\/\/1grid.co.za\/knowledge\/what-databases-does-1-grid-support\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>What Databases Does 1-grid Support?\u00a0<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-what-versions-of-php-does-cpanel-with-1-grid-support\"><a href=\"https:\/\/1grid.co.za\/knowledge\/what-php-versions-does-cpanel-with-1-grid-support\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>What Versions of PHP Does cPanel with 1-grid Support?\u00a0<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-mysql-guides\"><a href=\"https:\/\/1grid.co.za\/knowledge\/?s=MySQL&amp;ht-kb-search=1&amp;lang=\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>MySQL Guides<\/strong><\/a><\/li>\n<\/ul>\n\n\n\n<h2 id=\"htoc-faqs\" class=\"wp-block-heading\"><strong>FAQs<\/strong>&nbsp;<\/h2>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>What is Remote MySQL access?\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-it-allows-applications-or-servers-outside-your-hosting-environment-to-connect-directly-to-your-database\">It allows applications or servers outside your hosting environment to connect directly to your database.\u00a0<\/p>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>Is Remote MySQL access enabled by default?\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-no-remote-access-is-typically-restricted-for-security-reasons\">No. Remote access is typically restricted for security reasons.\u00a0<\/p>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>Can I allow access from any IP address?\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-technically-yes-but-this-is-not-recommended-due-to-security-risks\">Technically yes, but this is not recommended due to security risks.\u00a0<\/p>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>Why am I getting an &#8220;Access Denied&#8221; error?\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-this-usually-indicates-incorrect-credentials-insufficient-database-permissions-or-an-ip-address-that-has-not-been-allowlisted\">This usually\u00a0indicates\u00a0incorrect credentials, insufficient database permissions, or an IP address that has not been allowlisted.\u00a0<\/p>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>What port does MySQL use?\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-mysql-commonly-uses-port-3306\">MySQL commonly uses port 3306.\u00a0<\/p>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><strong>Can I disable remote access later?\u00a0<\/strong><\/summary>\n<p class=\"wp-block-paragraph\" id=\"htoc-yes-you-can-remove-allowlisted-ip-addresses-at-any-time-to-revoke-access\">Yes. You can remove allowlisted IP addresses at any time to revoke access.\u00a0<\/p>\n<\/details>\n\n\n\n<h2 id=\"htoc-empowering-insight\" class=\"wp-block-heading\"><strong>Empowering Insight<\/strong>&nbsp;<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"300\" src=\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2026\/03\/1-grid-Images-for-KB-Articles-1000-x-600-px-1600-x-300-px.png\" alt=\"Empowering Insight\" class=\"wp-image-34464\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Most Remote MySQL connection issues are caused by incorrect IP allowlisting,&nbsp;firewall&nbsp;restrictions, or invalid credentials rather than problems with the database itself. Verifying these settings first often resolves the issue quickly.&nbsp;<\/p>\n\n\n\n<h2 id=\"htoc-need-additional-support\" class=\"wp-block-heading\"><strong>Need Additional Support?<\/strong>&nbsp;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If\u00a0you&#8217;ve\u00a0followed the steps above and are still unable to connect, visit the <strong><a href=\"https:\/\/1grid.co.za\/knowledge\/\" target=\"_blank\" rel=\"noreferrer noopener\">1-grid Knowledge Base<\/a> <\/strong>for\u00a0additional\u00a0self-service guidance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you still require assistance, <strong><a href=\"https:\/\/1grid.co.za\/contact-us\/\" target=\"_blank\" rel=\"noreferrer noopener\">contact us<\/a> <\/strong>and our Support Team with the troubleshooting information listed above so we can\u00a0assist\u00a0you more efficiently.\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Databases\u00a0contain\u00a0critical website information, which means that remote MySQL access is restricted by default to help protect your data.\u00a0 This guide will help you configure Remote MySQL access for your hosting account, allowing approved external applications, servers, or development tools to connect securely to your database.&nbsp; By the end of this&#8230;<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[1198,1174,1199],"ht-kb-tag":[1858,238,1856,1848,1857,662,747,1855],"class_list":["post-34908","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cpanel","ht_kb_category-hosting","ht_kb_category-plesk","ht_kb_tag-advanced-hosting","ht_kb_tag-cpanel","ht_kb_tag-database-security","ht_kb_tag-databases","ht_kb_tag-hosting-configuration","ht_kb_tag-mysql","ht_kb_tag-plesk","ht_kb_tag-remote-access"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0 - 1-grid Knowledge Base<\/title>\n<meta name=\"description\" content=\"Learn how to securely configure Remote MySQL access on 1-grid hosting, including IP allowlisting, firewall requirements, and tips.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0 - 1-grid Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"Learn how to securely configure Remote MySQL access on 1-grid hosting, including IP allowlisting, firewall requirements, and tips.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/\" \/>\n<meta property=\"og:site_name\" content=\"1-grid Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/1grid.co.za\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-10T11:30:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2026\/07\/1-grid-Images-for-KB-Articles-1000-x-600-px-56.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@1grid_hosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/\",\"name\":\"Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0 - 1-grid Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\"},\"datePublished\":\"2026-07-10T11:30:34+00:00\",\"dateModified\":\"2026-07-10T11:30:35+00:00\",\"description\":\"Learn how to securely configure Remote MySQL access on 1-grid hosting, including IP allowlisting, firewall requirements, and tips.\",\"breadcrumb\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1grid.co.za\/knowledge\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"contentUrl\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"width\":100,\"height\":100,\"caption\":\"1-Grid Domain Hosting Knowledge Base\"},\"image\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/1grid.co.za\/\",\"https:\/\/twitter.com\/1grid_hosting\",\"https:\/\/www.instagram.com\/1grid_hosting\/\",\"https:\/\/za.linkedin.com\/company\/1-grid\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0 - 1-grid Knowledge Base","description":"Learn how to securely configure Remote MySQL access on 1-grid hosting, including IP allowlisting, firewall requirements, and tips.","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:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/","og_locale":"en_US","og_type":"article","og_title":"Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0 - 1-grid Knowledge Base","og_description":"Learn how to securely configure Remote MySQL access on 1-grid hosting, including IP allowlisting, firewall requirements, and tips.","og_url":"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/","og_site_name":"1-grid Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/1grid.co.za\/","article_modified_time":"2026-07-10T11:30:35+00:00","og_image":[{"url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2026\/07\/1-grid-Images-for-KB-Articles-1000-x-600-px-56.png"}],"twitter_card":"summary_large_image","twitter_site":"@1grid_hosting","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/","url":"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/","name":"Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0 - 1-grid Knowledge Base","isPartOf":{"@id":"https:\/\/1grid.co.za\/knowledge\/#website"},"datePublished":"2026-07-10T11:30:34+00:00","dateModified":"2026-07-10T11:30:35+00:00","description":"Learn how to securely configure Remote MySQL access on 1-grid hosting, including IP allowlisting, firewall requirements, and tips.","breadcrumb":{"@id":"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1grid.co.za\/knowledge\/remote-mysql-access-how-to-configure-on-1-grid-hosting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1grid.co.za\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Remote MySQL Access: How to Configure on 1-grid Hosting\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/1grid.co.za\/knowledge\/#website","url":"https:\/\/1grid.co.za\/knowledge\/","name":"1-Grid Domain Hosting Knowledge Base","description":"","publisher":{"@id":"https:\/\/1grid.co.za\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/1grid.co.za\/knowledge\/#organization","name":"1-Grid Domain Hosting Knowledge Base","url":"https:\/\/1grid.co.za\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","contentUrl":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","width":100,"height":100,"caption":"1-Grid Domain Hosting Knowledge Base"},"image":{"@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/1grid.co.za\/","https:\/\/twitter.com\/1grid_hosting","https:\/\/www.instagram.com\/1grid_hosting\/","https:\/\/za.linkedin.com\/company\/1-grid"]}]}},"_links":{"self":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/34908","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/comments?post=34908"}],"version-history":[{"count":6,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/34908\/revisions"}],"predecessor-version":[{"id":34920,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/34908\/revisions\/34920"}],"wp:attachment":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/media?parent=34908"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-category?post=34908"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-tag?post=34908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}