{"id":248035,"date":"2026-01-23T00:35:26","date_gmt":"2026-01-23T00:35:26","guid":{"rendered":"https:\/\/www.bluehost.com\/blog\/?p=248035"},"modified":"2026-01-23T06:32:15","modified_gmt":"2026-01-23T06:32:15","slug":"remote-database-connection-setup","status":"publish","type":"post","link":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/","title":{"rendered":"How to Set Up a Remote MySQL Database Connection via cPanel"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Key highlights<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Learn how to configure remote MySQL access settings in cPanel for secure external database connections<\/li>\n\n\n\n<li>Understand the security best practices for authorizing specific IP addresses and hosts<\/li>\n\n\n\n<li>Discover the step-by-step process to add remote hosts to your MySQL database access list<\/li>\n\n\n\n<li>Master troubleshooting techniques for resolving common remote MySQL connection errors<\/li>\n\n\n\n<li>Explore methods to test and verify your remote database connection is working properly<\/li>\n<\/ul>\n\n\n\n<p>Ever found yourself locked out of your own database when working remotely?&nbsp;You&#8217;re&nbsp;not alone. Many developers and website owners struggle with&nbsp;accessing their MySQL databases&nbsp;from external locations, leading to frustrating delays and productivity losses.&nbsp;&nbsp;<\/p>\n\n\n\n<p>Learning how to set up a remote MySQL database connection is essential for managing your website efficiently, whether&nbsp;you&#8217;re&nbsp;traveling, working from&nbsp;home&nbsp;or collaborating with a distributed team.&nbsp;&nbsp;<\/p>\n\n\n\n<p>In this comprehensive guide, we&#8217;ll walk you through the exact steps to configure remote MySQL access in cPanel, ensuring you can securely connect to your database from anywhere in the world.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why do you need a remote database connection?<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.bluehost.com\/help\/article\/remote-database-connection-setup\" target=\"_blank\" rel=\"noreferrer noopener\">Setting up a remote database connection<\/a>&nbsp;essentially gives&nbsp;your MySQL database permission to communicate with servers outside your hosting account. Think of it like opening a secure door that lets external applications and websites access your database from anywhere. This feature becomes incredibly handy when&nbsp;you&#8217;re&nbsp;working with multiple servers or applications that need to share data.&nbsp;&nbsp;<\/p>\n\n\n\n<p>For instance,&nbsp;if a mobile app needs data from your&nbsp;website\u2019s&nbsp;database, remote access is&nbsp;required. It is also useful for business intelligence tools&nbsp;analyzing&nbsp;live data. Developers benefit by connecting local environments to live databases. Businesses also&nbsp;need it&nbsp;to integrate websites with third-party services and platforms.&nbsp;<\/p>\n\n\n\n<p>Let&#8217;s&nbsp;see how to set up a remote MySQL database connection in cPanel.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cpanel-connection\">How to set up a remote MySQL database connection in cPanel?<\/h2>\n\n\n\n<p>Setting up a remote MySQL database connection allows external applications to securely access your database. This is essential for apps, analytics&nbsp;tools&nbsp;and developers working outside the hosting environment.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"requirements\">Requirements for remote MySQL database connection:<\/h3>\n\n\n\n<p>To connect remotely, you\u2019ll need:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A MySQL client (example,&nbsp;<a href=\"https:\/\/www.navicat.com\/en\/products\/navicat-for-mysql\" target=\"_blank\">Navicat<\/a>,&nbsp;<a href=\"https:\/\/www.phpmyadmin.net\/\" target=\"_blank\">phpMyAdmin<\/a>,&nbsp;<a href=\"https:\/\/wb.mysql.com\/\" target=\"_blank\">Workbench<\/a> or&nbsp;<a href=\"https:\/\/www.adobe.com\/mena\/products\/dreamweaver\" target=\"_blank\">Dreamweaver<\/a>)<\/li>\n\n\n\n<li>Your server\u2019s IP address<\/li>\n\n\n\n<li>Database credentials (name, username, password)<\/li>\n\n\n\n<li>Port 3306 (default MySQL port)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"configuration\">Configuration settings for remote database connection:<\/h3>\n\n\n\n<p>Use the following settings to connect to your database remotely:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Host name<\/strong>: Your server\u2019s IP address<\/li>\n\n\n\n<li><strong>Database name<\/strong>:&nbsp;<code>cpanelUsername_databaseName<\/code><\/li>\n\n\n\n<li><strong>Username<\/strong>:&nbsp;<code>cpanelUsername_databaseUsername<\/code><\/li>\n\n\n\n<li><strong>Password<\/strong>: The password for the database user<\/li>\n\n\n\n<li><strong>Port<\/strong>: 3306<\/li>\n\n\n\n<li><strong>Protocol<\/strong>: TCP or UDP<\/li>\n<\/ul>\n\n\n\n<p>If you haven\u2019t created your database yet, refer to our guide on&nbsp;<a href=\"https:\/\/www.bluehost.com\/help\/article\/how-to-create-and-delete-mysql-databases-and-users\" target=\"_blank\">creating and deleting MySQL databases<\/a>.<\/p>\n\n\n\n<p>Next,&nbsp;let\u2019s&nbsp;see how to set your remote MySQL connection effectively.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"remote-mysql\">How to set up remote MySQL connection?<\/h2>\n\n\n\n<p>To allow remote access:<\/p>\n\n\n\n<p>1. Log in to&nbsp;<a href=\"https:\/\/www.bluehost.com\/help\/article\/cpanel-access\" target=\"_blank\">cPanel<\/a>.<\/p>\n\n\n\n<p>2. Navigate to&nbsp;Remote MySQL&nbsp;under the&nbsp;Databases&nbsp;section.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2025\/10\/databases-remotemysql-1024x443.png\" alt=\"Navigate to\u00a0Remote MySQL\u00a0under the\u00a0Databases\u00a0section\"\/><\/figure>\n\n\n\n<p>3. Enter the IP address of the remote server or device in the&nbsp;Host&nbsp;field.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2025\/10\/databases-remotemysql-add-host-1024x411.png\" alt=\"Enter the IP address of the remote server or device in the\u00a0Host\u00a0field\"\/><\/figure>\n\n\n\n<p>4. Click&nbsp;Add Host.<\/p>\n\n\n\n<p>You can use wildcards (e.g., 192.168.0.%) to allow a range of IPs, but ensure they are secure and under your control.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Understanding IP address whitelisting and access control<\/h3>\n\n\n\n<p>IP whitelisting acts as a <a title=\"Whitelist IP Address\" href=\"https:\/\/www.bluehost.com\/help\/article\/whitelist-ip-address\" target=\"_blank\">strict security checkpoint<\/a> for your cPanel remote MySQL connection, ensuring only authorized locations can access your sensitive data. When you add a specific IP address to the access list, the server blocks all other connection attempts, which is vital for maintaining robust database security. You can easily identify your <a title=\"How to Find Your Public IP Address\" href=\"https:\/\/www.bluehost.com\/help\/article\/find-public-ip\" target=\"_blank\">current public IP address<\/a> by searching &#8220;what is my IP&#8221; in your browser before configuring your settings.<\/p>\n\n\n\n<p>If your internet connection uses dynamic IP addresses that change frequently, you might need to update your allowlist often or use a wildcard character (%) to permit a range of IPs, such as <code>192.168.%<\/code>. However, exercise extreme caution when using wildcards in your remote database access hosts cPanel configurations, as defining broad ranges can inadvertently expose your database to attackers. For optimal security, prioritize whitelisting individual static IPs over ranges and never use the wildcard character alone unless absolutely necessary.<\/p>\n\n\n\n<p>Next, see how to remove&nbsp;the access&nbsp;host.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"remove-access\">How to remove the remote access host?<\/h2>\n\n\n\n<p>To revoke access:<\/p>\n\n\n\n<p>1. Go to&nbsp;Manage Access Hosts.<\/p>\n\n\n\n<p>2. Click the&nbsp;trash&nbsp;icon beside the IP you want to remove.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2025\/10\/databases-remotemysql-remove-host-1024x397.png\" alt=\"Manage Access Hosts in cPanel to set up or remove a remote MySQL database connection\"\/><\/figure>\n\n\n\n<p>3. Confirm by clicking&nbsp;Remove Access Host.<\/p>\n\n\n\n<p>If your IP address changes frequently (dynamic IP), you\u2019ll need to update it each time.<\/p>\n\n\n\n<p>Now that you understand how to set up and remove your remote access,&nbsp;let\u2019s&nbsp;see how to manage it in WHM.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to manage remote MySQL access in Web Host Manager?<\/h2>\n\n\n\n<p>While cPanel allows individual users to manage their specific remote database access hosts, cPanel settings,&nbsp;<a href=\"https:\/\/www.bluehost.com\/help\/article\/whm-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Web Host Manager<\/a>&nbsp;(WHM) provides server administrators with a broader level of control. Managing remote MySQL access in WHM is essential when you need to enforce server-wide policies or grant access to a specific remote host across multiple accounts simultaneously.&nbsp;&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Why&nbsp;use WHM for&nbsp;remote MySQL&nbsp;access?&nbsp;<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Provides&nbsp;server-wide control&nbsp;instead of per-account configuration&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Helps enforce&nbsp;uniform access policies&nbsp;across multiple cPanel users&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ideal when multiple clients or tools connect from the&nbsp;same external IP&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reduces manual effort compared to updating each cPanel account separately&nbsp;<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Steps to&nbsp;configure&nbsp;remote MySQL&nbsp;access in WHM&nbsp;<\/h3>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Log&nbsp;in to&nbsp;Web Host Manager (WHM)&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Navigate to&nbsp;SQL Services&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Select&nbsp;Additional MySQL Access Hosts&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Enter the&nbsp;IP addresses or hostnames&nbsp;you want to whitelist&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>Save the entries to add them to the global allowed hosts list&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>Click&nbsp;\u201cManage Your Access Hosts\u201d&nbsp;to apply settings to all users or selected accounts&nbsp;<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Important&nbsp;considerations&nbsp;<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WHM settings&nbsp;work alongside user-level cPanel configurations&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Users can still manage their own allowed hosts independently&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The global list ensures reliable access for&nbsp;support teams and monitoring tools&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Confirm your server&nbsp;firewall&nbsp;allows traffic on&nbsp;MySQL port 3306&nbsp;to avoid connection issues&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>Managing remote MySQL access through WHM simplifies administration and is essential for enterprise or reseller hosting environments.&nbsp;<\/p>\n\n\n\n<p>Next, explore effective database management to improve performance and overall efficiency.&nbsp;&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"database-management\">How to do database management?<\/h2>\n\n\n\n<p>Once the IP is whitelisted, use your MySQL client to connect using the credentials found in cPanel\u2019s&nbsp;<a href=\"https:\/\/www.bluehost.com\/help\/article\/how-to-create-and-delete-mysql-databases-and-users\" target=\"_blank\">MySQL Databases<\/a>&nbsp;section.&nbsp;<a href=\"https:\/\/www.bluehost.com\/help\/article\/mysql-error-messages\" target=\"_blank\">Common connection issues<\/a>&nbsp;often stem from incorrect usernames or passwords. Double-check your credentials and ensure port 3306 is open.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Security best practices for remote MySQL connections<\/h2>\n\n\n\n<p>Opening your database to external connections requires rigorous security measures to prevent unauthorized access. Start by strictly limiting &#8220;remote database access hosts cPanel&#8221; settings to specific, static IP addresses rather than using wildcards, which can leave your system vulnerable. Always <a title=\"How to Create a Strong Password\" href=\"https:\/\/www.bluehost.com\/help\/article\/how-to-create-a-strong-password\" target=\"_blank\">enforce strong, complex passwords<\/a> for every database user and rotate these credentials regularly to mitigate brute-force risks. When you enable &#8220;cPanel remote MySQL&#8221; access, never use the root account; instead, adhere to the principle of least privilege by creating dedicated users with only the specific permissions required for their tasks.<\/p>\n\n\n\n<p>Data encryption and ongoing monitoring are equally vital for maintaining a secure &#8220;remote MySQL hosting&#8221; environment. Configure your connections to use SSL\/TLS encryption so sensitive data remains unreadable during transit. You must also protect the default &#8220;cPanel MySQL port&#8221; (3306) by configuring your firewall to filter traffic and block suspicious IPs. Regularly review your connection logs for anomalies, set up alerts for repeated failed authentication attempts and ensure both your cPanel and MySQL software are updated to the latest versions to <a title=\"How to Upgrade cPanel Software\" href=\"https:\/\/www.bluehost.com\/help\/article\/upgrade-cpanel-software\" target=\"_blank\">patch known vulnerabilities<\/a>. Conducting periodic security audits will help you stay ahead of potential threats.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Testing your remote database connection<\/h3>\n\n\n\n<p>To verify your remote database access hosts&#8217; cPanel configuration, attempt a connection using a terminal command like <code>mysql -u username -p -h server_ip<\/code> or a GUI tool such as MySQL Workbench. A successful connection yields a command prompt or dashboard access, confirming that your credentials are valid and the server is reachable. Conversely, a &#8220;connection refused&#8221; or timeout error often signals that the cPanel MySQL port (3306) is being blocked by a firewall or that your IP address is missing from the allowlist.<\/p>\n\n\n\n<p>If you can connect but cannot view tables, verify your user permissions within cPanel. For automated verification, run a simple PHP connection script from your remote machine to test the link programmatically. Should tests fail repeatedly, confirm that your local network allows outbound traffic on port 3306 and ensure your cPanel remote MySQL settings explicitly list your current public IP address.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Using MySQL Workbench for remote connections<\/h3>\n\n\n\n<p>To start managing your database, open MySQL Workbench and click the plus icon (+) next to &#8220;MySQL Connections.&#8221; In the configuration window, assign a name to your connection and enter your server&#8217;s IP address as the Hostname. Verify that the cPanel MySQL port is set to 3306, then input your specific database username and password. Click &#8220;Test Connection&#8221; to confirm your settings are correct; a successful message indicates your credentials work and the server is reachable.<\/p>\n\n\n\n<p>Upon connecting, the Workbench dashboard allows you to visually navigate schemas, run complex SQL queries and manage table structures efficiently. If the connection fails, the most common culprit is an unauthorized IP address, so ensure your current IP is added to the cPanel remote MySQL access list. This visual approach simplifies database administration, making it easier to handle remote operations without relying solely on command-line tools.<\/p>\n\n\n\n<p>Next,&nbsp;let\u2019s&nbsp;see how to fix common connection issues.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Troubleshooting common connection issues<\/h2>\n\n\n\n<p>Troubleshooting a cPanel remote MySQL connection often involves isolating whether the issue is network-related or credential-based. If you encounter an &#8220;Access Denied&#8221; (Error 1045) message, this confirms the server is reachable, but your authentication failed. This usually happens when the password is incorrect or your IP address is missing from the remote database access hosts&#8217; cPanel list. Remember that dynamic IPs change frequently, so a connection that worked yesterday might fail today if your ISP assigned a new address.<\/p>\n\n\n\n<p>&#8220;Connection Refused&#8221; or timeout errors (Error 2003) suggest a firewall is blocking the traffic before it reaches the database. Ensure your local network allows outbound traffic on the standard cPanel MySQL port (3306). Windows users should check Windows Defender Firewall, while Mac users may need to adjust System Settings. If you are using remote MySQL hosting tools like MySQL Workbench, verify the hostname matches your server IP rather than &#8220;localhost.&#8221;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Check credentials:<\/strong> Re-verify your database username and password in the MySQL Databases section of cPanel.<\/li>\n\n\n\n<li><strong>Whitelist IP:<\/strong> Google &#8220;what is my IP&#8221; and ensure that exact address is added to Remote MySQL.<\/li>\n\n\n\n<li><strong>Test port 3306:<\/strong> Use Telnet or a terminal command to confirm your computer can reach the server port.<\/li>\n<\/ul>\n\n\n\n<p>Setting up a Remote MySQL Database Connection in cPanel allows you to manage your databases from anywhere using trusted tools and secure configurations. By following the steps above, you can ensure reliable and secure access to your MySQL databases. For further troubleshooting, check out our related article on MySQL Errors.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Final thoughts<\/h2>\n\n\n\n<p>Understanding how to set up a remote MySQL database connection in cPanel gives you greater control over how your applications access and manage data. From enabling secure IP access to assigning the right database privileges, each step helps ensure reliable performance and safe remote connectivity.&nbsp;&nbsp;<\/p>\n\n\n\n<p>As your projects grow, so do your infrastructure needs, especially when handling external applications or multiple servers. If&nbsp;you\u2019re&nbsp;looking for more power,&nbsp;flexibility&nbsp;and full server-level control, upgrading your hosting environment makes sense.&nbsp;<\/p>\n\n\n\n<p>Explore <a href=\"https:\/\/www.bluehost.com\/vps-hosting#pricing-cards\">Bluehost VPS hosting plans<\/a> to support scalable database management with confidence.<\/p>\n\n\n\n<svg version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\" viewBox=\"0 0 1001 300\"> \n<image width=\"1001\" height=\"300\" href=\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2025\/03\/VPS-Hosting-1.png\"><\/image> <a href=\"https:\/\/www.bluehost.com\/vps-hosting\"> \n<rect x=\"82\" y=\"201\" fill=\"#fff\" opacity=\"0\" width=\"173\" height=\"63\"><\/rect> \n<\/a> \n<\/svg>\n\n\n\n<h2 class=\"wp-block-heading\">FAQs<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1769128709608\"><strong class=\"schema-faq-question\"><strong>What is a remote MySQL database connection?<\/strong><\/strong> <p class=\"schema-faq-answer\">A remote MySQL database connection allows external servers or applications to access your database from different IP addresses, enabling seamless integration with web applications, mobile apps and third-party services hosted elsewhere.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1769128727416\"><strong class=\"schema-faq-question\"><strong>How do I add a remote host in cPanel?<\/strong><\/strong> <p class=\"schema-faq-answer\">Log into cPanel, navigate to the Databases section, select Remote MySQL, enter the IP address or domain you want to grant access to and click Add Host to authorize the connection.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1769128752032\"><strong class=\"schema-faq-question\"><strong>Can I use a wildcard for remote MySQL access?<\/strong><\/strong> <p class=\"schema-faq-answer\">Yes, you can use the wildcard symbol (%) to allow connections from any IP address. However, this poses significant security risks and should only be used in controlled development environments, never in production.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1769128766064\"><strong class=\"schema-faq-question\"><strong>Why is my remote MySQL connection failing?<\/strong><\/strong> <p class=\"schema-faq-answer\">Connection failures typically occur due to incorrect IP address configuration, firewall restrictions, wrong database credentials or server-side port blocking. Verify your remote host settings and confirm port 3306 is accessible through your firewall.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1769128787745\"><strong class=\"schema-faq-question\"><strong>How do I find my server&#8217;s IP address for remote access?<\/strong><\/strong> <p class=\"schema-faq-answer\">You can find your server&#8217;s IP address in cPanel under the Stats section on the right sidebar or contact your hosting provider. For dynamic IPs, consider using your domain name instead.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1769128810104\"><strong class=\"schema-faq-question\"><strong>Is remote MySQL access secure in cPanel?<\/strong><\/strong> <p class=\"schema-faq-answer\">Remote MySQL access can be secure when properly configured using specific IP addresses, strong passwords, SSL\/TLS encryption and limiting database user privileges. Avoid using wildcards and regularly monitor your access logs for security.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1769128823672\"><strong class=\"schema-faq-question\"><strong>How do I remove a remote host from MySQL?<\/strong><\/strong> <p class=\"schema-faq-answer\">In cPanel&#8217;s Remote MySQL section, locate the host you want to remove from the Access Hosts list, click the Delete button next to that entry and confirm the removal to revoke access immediately.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Set up a remote MySQL database connection in cPanel securely and efficiently, with clear steps to connect external apps with confidence. <\/p>\n","protected":false},"author":145,"featured_media":263204,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_yoast_wpseo_title":"How to Set Up a Remote MySQL Database Connection via cPanel","_yoast_wpseo_metadesc":"How to Set Up a Remote MySQL Database Connection: Configure cPanel remote database access hosts, enable port 3306 & connect external applications securely.","inline_featured_image":false,"footnotes":""},"categories":[3046],"tags":[3330],"ppma_author":[943],"class_list":["post-248035","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-how-to-guides"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.1 (Yoast SEO v27.1.1) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Set Up a Remote MySQL Database Connection via cPanel<\/title>\n<meta name=\"description\" content=\"How to Set Up a Remote MySQL Database Connection: Configure cPanel remote database access hosts, enable port 3306 &amp; connect external applications securely.\" \/>\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.bluehost.com\/blog\/wp-json\/wp\/v2\/posts\/248035\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Set Up a Remote MySQL Database Connection via cPanel\" \/>\n<meta property=\"og:description\" content=\"How to Set Up a Remote MySQL Database Connection: Configure cPanel remote database access hosts, enable port 3306 &amp; connect external applications securely.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/\" \/>\n<meta property=\"og:site_name\" content=\"Bluehost Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/bluehost\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-23T00:35:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-23T06:32:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Punya Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bluehost\" \/>\n<meta name=\"twitter:site\" content=\"@bluehost\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Punya Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/\"},\"author\":{\"name\":\"Punya Singh\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/#\/schema\/person\/18ce29a81daa994f05db5cfb38e58c59\"},\"headline\":\"How to Set Up a Remote MySQL Database Connection via cPanel\",\"datePublished\":\"2026-01-23T00:35:26+00:00\",\"dateModified\":\"2026-01-23T06:32:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/\"},\"wordCount\":2273,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png\",\"keywords\":[\"How-To Guides\"],\"articleSection\":[\"Development\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/\",\"url\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/\",\"name\":\"How to Set Up a Remote MySQL Database Connection via cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png\",\"datePublished\":\"2026-01-23T00:35:26+00:00\",\"dateModified\":\"2026-01-23T06:32:15+00:00\",\"description\":\"How to Set Up a Remote MySQL Database Connection: Configure cPanel remote database access hosts, enable port 3306 & connect external applications securely.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128709608\"},{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128727416\"},{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128752032\"},{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128766064\"},{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128787745\"},{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128810104\"},{\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128823672\"}],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#primaryimage\",\"url\":\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png\",\"contentUrl\":\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png\",\"width\":1200,\"height\":630,\"caption\":\"How to Set Up a Remote MySQL Database Connection\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bluehost.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WordPress\",\"item\":\"https:\/\/www.bluehost.com\/blog\/category\/wordpress\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Development\",\"item\":\"https:\/\/www.bluehost.com\/blog\/category\/wordpress\/development\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"How to Set Up a Remote MySQL Database Connection via cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/#website\",\"url\":\"https:\/\/www.bluehost.com\/blog\/\",\"name\":\"Bluehost\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bluehost.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/#organization\",\"name\":\"Bluehost\",\"url\":\"https:\/\/www.bluehost.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2023\/08\/bluehost-logo.svg\",\"contentUrl\":\"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2023\/08\/bluehost-logo.svg\",\"width\":136,\"height\":24,\"caption\":\"Bluehost\"},\"image\":{\"@id\":\"https:\/\/www.bluehost.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/bluehost\/\",\"https:\/\/x.com\/bluehost\",\"https:\/\/www.linkedin.com\/company\/bluehost-com\/\",\"https:\/\/www.youtube.com\/user\/bluehost\",\"https:\/\/en.wikipedia.org\/wiki\/Bluehost\"],\"description\":\"Bluehost is a leading web hosting provider empowering millions of websites worldwide. \\u2028Discover how Bluehost's expertise, reliability, and innovation can help you achieve your online goals.\",\"telephone\":\"+1-888-401-4678\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/#\/schema\/person\/18ce29a81daa994f05db5cfb38e58c59\",\"name\":\"Punya Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/#\/schema\/person\/image\/e7f2663cb3dc74fb27047d17bf218f32\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dc583b69d51f8c1619d8fb10fd7a1778cb73163e102493c4be47d084d8e762c5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dc583b69d51f8c1619d8fb10fd7a1778cb73163e102493c4be47d084d8e762c5?s=96&d=mm&r=g\",\"caption\":\"Punya Singh\"},\"description\":\"Punya is a seasoned marketing strategist with over 5 years of experience, specializing in simplifying complex technical concepts into simpler insights. A culinary adventurer at heart, she enjoys exploring exotic cuisines, fusing her passion for creativity with a zest for life.\",\"url\":\"https:\/\/www.bluehost.com\/blog\/author\/punya-singh\/\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128709608\",\"position\":1,\"url\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128709608\",\"name\":\"What is a remote MySQL database connection?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"A remote MySQL database connection allows external servers or applications to access your database from different IP addresses, enabling seamless integration with web applications, mobile apps and third-party services hosted elsewhere.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128727416\",\"position\":2,\"url\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128727416\",\"name\":\"How do I add a remote host in cPanel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Log into cPanel, navigate to the Databases section, select Remote MySQL, enter the IP address or domain you want to grant access to and click Add Host to authorize the connection.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128752032\",\"position\":3,\"url\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128752032\",\"name\":\"Can I use a wildcard for remote MySQL access?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes, you can use the wildcard symbol (%) to allow connections from any IP address. However, this poses significant security risks and should only be used in controlled development environments, never in production.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128766064\",\"position\":4,\"url\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128766064\",\"name\":\"Why is my remote MySQL connection failing?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Connection failures typically occur due to incorrect IP address configuration, firewall restrictions, wrong database credentials or server-side port blocking. Verify your remote host settings and confirm port 3306 is accessible through your firewall.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128787745\",\"position\":5,\"url\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128787745\",\"name\":\"How do I find my server's IP address for remote access?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"You can find your server's IP address in cPanel under the Stats section on the right sidebar or contact your hosting provider. For dynamic IPs, consider using your domain name instead.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128810104\",\"position\":6,\"url\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128810104\",\"name\":\"Is remote MySQL access secure in cPanel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Remote MySQL access can be secure when properly configured using specific IP addresses, strong passwords, SSL\/TLS encryption and limiting database user privileges. Avoid using wildcards and regularly monitor your access logs for security.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128823672\",\"position\":7,\"url\":\"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128823672\",\"name\":\"How do I remove a remote host from MySQL?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"In cPanel's Remote MySQL section, locate the host you want to remove from the Access Hosts list, click the Delete button next to that entry and confirm the removal to revoke access immediately.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Set Up a Remote MySQL Database Connection via cPanel","description":"How to Set Up a Remote MySQL Database Connection: Configure cPanel remote database access hosts, enable port 3306 & connect external applications securely.","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.bluehost.com\/blog\/wp-json\/wp\/v2\/posts\/248035\/","og_locale":"en_US","og_type":"article","og_title":"How to Set Up a Remote MySQL Database Connection via cPanel","og_description":"How to Set Up a Remote MySQL Database Connection: Configure cPanel remote database access hosts, enable port 3306 & connect external applications securely.","og_url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/","og_site_name":"Bluehost Blog","article_publisher":"https:\/\/www.facebook.com\/bluehost\/","article_published_time":"2026-01-23T00:35:26+00:00","article_modified_time":"2026-01-23T06:32:15+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png","type":"image\/png"}],"author":"Punya Singh","twitter_card":"summary_large_image","twitter_creator":"@bluehost","twitter_site":"@bluehost","twitter_misc":{"Written by":"Punya Singh","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#article","isPartOf":{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/"},"author":{"name":"Punya Singh","@id":"https:\/\/www.bluehost.com\/blog\/#\/schema\/person\/18ce29a81daa994f05db5cfb38e58c59"},"headline":"How to Set Up a Remote MySQL Database Connection via cPanel","datePublished":"2026-01-23T00:35:26+00:00","dateModified":"2026-01-23T06:32:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/"},"wordCount":2273,"commentCount":0,"publisher":{"@id":"https:\/\/www.bluehost.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png","keywords":["How-To Guides"],"articleSection":["Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/","url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/","name":"How to Set Up a Remote MySQL Database Connection via cPanel","isPartOf":{"@id":"https:\/\/www.bluehost.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#primaryimage"},"image":{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png","datePublished":"2026-01-23T00:35:26+00:00","dateModified":"2026-01-23T06:32:15+00:00","description":"How to Set Up a Remote MySQL Database Connection: Configure cPanel remote database access hosts, enable port 3306 & connect external applications securely.","breadcrumb":{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128709608"},{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128727416"},{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128752032"},{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128766064"},{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128787745"},{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128810104"},{"@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128823672"}],"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#primaryimage","url":"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png","contentUrl":"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2026\/01\/How-to-Set-Up-a-Remote-MySQL-Database-Connection-in-cPanel.png","width":1200,"height":630,"caption":"How to Set Up a Remote MySQL Database Connection"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bluehost.com\/blog\/"},{"@type":"ListItem","position":2,"name":"WordPress","item":"https:\/\/www.bluehost.com\/blog\/category\/wordpress\/"},{"@type":"ListItem","position":3,"name":"Development","item":"https:\/\/www.bluehost.com\/blog\/category\/wordpress\/development\/"},{"@type":"ListItem","position":4,"name":"How to Set Up a Remote MySQL Database Connection via cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.bluehost.com\/blog\/#website","url":"https:\/\/www.bluehost.com\/blog\/","name":"Bluehost","description":"","publisher":{"@id":"https:\/\/www.bluehost.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bluehost.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bluehost.com\/blog\/#organization","name":"Bluehost","url":"https:\/\/www.bluehost.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bluehost.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2023\/08\/bluehost-logo.svg","contentUrl":"https:\/\/www.bluehost.com\/blog\/wp-content\/uploads\/2023\/08\/bluehost-logo.svg","width":136,"height":24,"caption":"Bluehost"},"image":{"@id":"https:\/\/www.bluehost.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/bluehost\/","https:\/\/x.com\/bluehost","https:\/\/www.linkedin.com\/company\/bluehost-com\/","https:\/\/www.youtube.com\/user\/bluehost","https:\/\/en.wikipedia.org\/wiki\/Bluehost"],"description":"Bluehost is a leading web hosting provider empowering millions of websites worldwide. \u2028Discover how Bluehost's expertise, reliability, and innovation can help you achieve your online goals.","telephone":"+1-888-401-4678"},{"@type":"Person","@id":"https:\/\/www.bluehost.com\/blog\/#\/schema\/person\/18ce29a81daa994f05db5cfb38e58c59","name":"Punya Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bluehost.com\/blog\/#\/schema\/person\/image\/e7f2663cb3dc74fb27047d17bf218f32","url":"https:\/\/secure.gravatar.com\/avatar\/dc583b69d51f8c1619d8fb10fd7a1778cb73163e102493c4be47d084d8e762c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc583b69d51f8c1619d8fb10fd7a1778cb73163e102493c4be47d084d8e762c5?s=96&d=mm&r=g","caption":"Punya Singh"},"description":"Punya is a seasoned marketing strategist with over 5 years of experience, specializing in simplifying complex technical concepts into simpler insights. A culinary adventurer at heart, she enjoys exploring exotic cuisines, fusing her passion for creativity with a zest for life.","url":"https:\/\/www.bluehost.com\/blog\/author\/punya-singh\/"},{"@type":"Question","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128709608","position":1,"url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128709608","name":"What is a remote MySQL database connection?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"A remote MySQL database connection allows external servers or applications to access your database from different IP addresses, enabling seamless integration with web applications, mobile apps and third-party services hosted elsewhere.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128727416","position":2,"url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128727416","name":"How do I add a remote host in cPanel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Log into cPanel, navigate to the Databases section, select Remote MySQL, enter the IP address or domain you want to grant access to and click Add Host to authorize the connection.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128752032","position":3,"url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128752032","name":"Can I use a wildcard for remote MySQL access?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Yes, you can use the wildcard symbol (%) to allow connections from any IP address. However, this poses significant security risks and should only be used in controlled development environments, never in production.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128766064","position":4,"url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128766064","name":"Why is my remote MySQL connection failing?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Connection failures typically occur due to incorrect IP address configuration, firewall restrictions, wrong database credentials or server-side port blocking. Verify your remote host settings and confirm port 3306 is accessible through your firewall.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128787745","position":5,"url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128787745","name":"How do I find my server's IP address for remote access?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"You can find your server's IP address in cPanel under the Stats section on the right sidebar or contact your hosting provider. For dynamic IPs, consider using your domain name instead.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128810104","position":6,"url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128810104","name":"Is remote MySQL access secure in cPanel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Remote MySQL access can be secure when properly configured using specific IP addresses, strong passwords, SSL\/TLS encryption and limiting database user privileges. Avoid using wildcards and regularly monitor your access logs for security.","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128823672","position":7,"url":"https:\/\/www.bluehost.com\/blog\/remote-database-connection-setup\/#faq-question-1769128823672","name":"How do I remove a remote host from MySQL?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"In cPanel's Remote MySQL section, locate the host you want to remove from the Access Hosts list, click the Delete button next to that entry and confirm the removal to revoke access immediately.","inLanguage":"en-US"},"inLanguage":"en-US"}]}},"authors":[{"term_id":943,"user_id":145,"is_guest":0,"slug":"punya-singh","display_name":"Punya Singh","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/dc583b69d51f8c1619d8fb10fd7a1778cb73163e102493c4be47d084d8e762c5?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":"","9":"","10":"","11":"","12":"","13":"","14":"","15":""}],"_links":{"self":[{"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/posts\/248035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/users\/145"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/comments?post=248035"}],"version-history":[{"count":4,"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/posts\/248035\/revisions"}],"predecessor-version":[{"id":263161,"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/posts\/248035\/revisions\/263161"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/media\/263204"}],"wp:attachment":[{"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/media?parent=248035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/categories?post=248035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/tags?post=248035"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.bluehost.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=248035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}