{"id":12167,"date":"2026-06-03T05:07:46","date_gmt":"2026-06-03T05:07:46","guid":{"rendered":"https:\/\/www.webystrata.com\/blog\/?p=12167"},"modified":"2026-06-06T09:37:02","modified_gmt":"2026-06-06T09:37:02","slug":"configure-remote-mysql-access-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.webystrata.com\/blog\/configure-remote-mysql-access-in-cpanel\/","title":{"rendered":"How to Configure Remote MySQL Access in cPanel"},"content":{"rendered":"<h1>How to Configure Remote MySQL Access in cPanel<\/h1>\n<p>Managing databases efficiently is essential for website owners, developers, and businesses. While most websites access their databases locally, there are situations where you may need to connect to a MySQL database from a remote server or application. This is where Remote MySQL Access in cPanel becomes useful.<\/p>\n<p>In this guide, you&#8217;ll learn what Remote MySQL Access is, why it&#8217;s important, and how to configure it securely using cPanel.<\/p>\n<h2>What is Remote MySQL Access?<\/h2>\n<p>Remote MySQL Access allows external servers, applications, or devices to connect to a MySQL database hosted on your web hosting account. By default, MySQL databases only accept connections from the local server for security reasons.<\/p>\n<p>When Remote MySQL Access is enabled, authorized external hosts can connect to your database using valid credentials.<\/p>\n<h2>Prerequisites<\/h2>\n<p>Before configuring Remote MySQL Access, ensure you have:<\/p>\n<ul>\n<li>Access to your cPanel account<\/li>\n<li>A MySQL database<\/li>\n<li>A MySQL database user<\/li>\n<li>The IP address of the remote server or device<\/li>\n<li>Database connection credentials<\/li>\n<\/ul>\n<h2>How to Configure Remote MySQL Access in cPanel<\/h2>\n<p>Follow these steps to allow remote connections to your MySQL database.<\/p>\n<h3 data-section-id=\"1hmzdnt\" data-start=\"203\" data-end=\"246\"><span style=\"color: #000000;\">Step 1: Login to cPanel from Client Area<\/span><\/h3>\n<p data-start=\"446\" data-end=\"570\">First, visit the WebyStrata website and log in to your client area account using your registered email address and password.<\/p>\n<p data-start=\"446\" data-end=\"570\">official Website <a href=\"https:\/\/www.webystrata.com\">www.webystrata.com<\/a><\/p>\n<p data-start=\"291\" data-end=\"308\"><span style=\"color: #000000;\">After logging in:<\/span><\/p>\n<ol data-start=\"310\" data-end=\"429\">\n<li data-section-id=\"ygoy3r\" data-start=\"310\" data-end=\"331\"><span style=\"color: #000000;\">Go to <strong data-start=\"319\" data-end=\"331\">Services<\/strong><\/span><\/li>\n<li data-section-id=\"wyqca4\" data-start=\"332\" data-end=\"359\"><span style=\"color: #000000;\">Click on <strong data-start=\"344\" data-end=\"359\">My Services<\/strong><\/span><\/li>\n<li data-section-id=\"8kxumo\" data-start=\"360\" data-end=\"397\"><span style=\"color: #000000;\">Select your active hosting service<\/span><\/li>\n<li data-section-id=\"4ekbul\" data-start=\"398\" data-end=\"429\"><span style=\"color: #000000;\">Click on <strong data-start=\"410\" data-end=\"429\">Login to cPanel<\/strong><\/span><\/li>\n<\/ol>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-11961 size-full\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/05\/login-into-cpanel-5.webp\" alt=\"how-to-configure-remote-mysql-access-in-cpanel\" width=\"1902\" height=\"957\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/05\/login-into-cpanel-5.webp 1902w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/05\/login-into-cpanel-5-300x151.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/05\/login-into-cpanel-5-1024x515.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/05\/login-into-cpanel-5-768x386.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/05\/login-into-cpanel-5-1536x773.webp 1536w\" sizes=\"(max-width: 1902px) 100vw, 1902px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3 data-section-id=\"76fqjg\" data-start=\"2221\" data-end=\"2257\"><span style=\"color: #000000;\">Step 2: Open Remote MySQL Section<\/span><\/h3>\n<ul data-start=\"2259\" data-end=\"2329\">\n<li data-section-id=\"15p5my2\" data-start=\"2259\" data-end=\"2301\"><span style=\"color: #000000;\">Scroll down to the <strong data-start=\"2280\" data-end=\"2293\">Databases<\/strong> section<\/span><\/li>\n<li data-section-id=\"u6uvt\" data-start=\"2302\" data-end=\"2329\"><span style=\"color: #000000;\">Click on <strong data-start=\"2313\" data-end=\"2329\">Remote MySQL<\/strong><\/span><\/li>\n<\/ul>\n<p data-start=\"2331\" data-end=\"2401\"><span style=\"color: #000000;\">This feature is provided inside <span class=\"hover:entity-accent entity-underline inline cursor-pointer align-baseline\"><span class=\"whitespace-normal\">cPanel<\/span><\/span>.<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-12175\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA.webp\" alt=\"how-to-configure-remote-mysql-access-in-cpanel\" width=\"1909\" height=\"894\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA.webp 1909w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA-300x140.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA-1024x480.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA-768x360.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA-1536x719.webp 1536w\" sizes=\"(max-width: 1909px) 100vw, 1909px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3 data-section-id=\"gg65i3\" data-start=\"2408\" data-end=\"2434\"><span style=\"color: #000000;\">Step 3: Add Remote Host<\/span><\/h3>\n<p data-start=\"2436\" data-end=\"2494\"><span style=\"color: #000000;\">You will see a field called <strong data-start=\"2464\" data-end=\"2493\">Host (% wildcard allowed)<\/strong>.<\/span><\/p>\n<p data-start=\"2496\" data-end=\"2553\"><span style=\"color: #000000;\">Enter the IP address of the remote server or application.<\/span><\/p>\n<p data-start=\"2555\" data-end=\"2563\"><span style=\"color: #000000;\">Example:<\/span><\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"relative\">\n<div class=\"pe-11 pt-3\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><span style=\"color: #000000;\"><code>192.168.1.10<\/code><\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2586\" data-end=\"2610\"><span style=\"color: #000000;\">Then click <strong data-start=\"2597\" data-end=\"2609\">Add Host<\/strong>.<\/span><\/p>\n<p data-start=\"2586\" data-end=\"2610\"><img decoding=\"async\" class=\"alignnone size-full wp-image-12176\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/add-host.webp\" alt=\"how-to-configure-remote-mysql-access-in-cpanel\" width=\"1906\" height=\"895\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/add-host.webp 1906w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/add-host-300x141.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/add-host-1024x481.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/add-host-768x361.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/add-host-1536x721.webp 1536w\" sizes=\"(max-width: 1906px) 100vw, 1906px\" \/><\/p>\n<p data-start=\"2586\" data-end=\"2610\">\n<h3 data-section-id=\"1j1tor2\" data-start=\"2617\" data-end=\"2645\"><span style=\"color: #000000;\">Step 4: Verify Host Added<\/span><\/h3>\n<p data-start=\"2647\" data-end=\"2709\"><span style=\"color: #000000;\">After adding, the IP will appear in the list of allowed hosts.<\/span><\/p>\n<p data-start=\"2711\" data-end=\"2784\"><span style=\"color: #000000;\">This means the server is now permitted to connect to your MySQL database.<\/span><\/p>\n<p data-start=\"2711\" data-end=\"2784\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12177\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/MAH.webp\" alt=\"how-to-configure-remote-mysql-access-in-cpanel\" width=\"1919\" height=\"893\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/MAH.webp 1919w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/MAH-300x140.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/MAH-1024x477.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/MAH-768x357.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/MAH-1536x715.webp 1536w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/p>\n<p data-start=\"2711\" data-end=\"2784\">\n<h3 data-section-id=\"1ryauc8\" data-start=\"512\" data-end=\"557\"><span style=\"color: #000000;\">Step 5: Connect to Your Database Remotely<\/span><\/h3>\n<p data-start=\"559\" data-end=\"668\"><span style=\"color: #000000;\">After enabling remote host access, you can connect to your MySQL database using any MySQL client application.<\/span><\/p>\n<p data-start=\"670\" data-end=\"709\"><span style=\"color: #000000;\">Use the following database credentials:<\/span><\/p>\n<ul data-start=\"711\" data-end=\"940\">\n<li data-section-id=\"1dpqm9i\" data-start=\"711\" data-end=\"766\"><span style=\"color: #000000;\"><strong data-start=\"713\" data-end=\"731\">Database Host:<\/strong> Your server hostname or IP address<\/span><\/li>\n<li data-section-id=\"1sog8c9\" data-start=\"767\" data-end=\"812\"><span style=\"color: #000000;\"><strong data-start=\"769\" data-end=\"787\">Database Name:<\/strong> Your MySQL database name<\/span><\/li>\n<li data-section-id=\"doau4c\" data-start=\"813\" data-end=\"857\"><span style=\"color: #000000;\"><strong data-start=\"815\" data-end=\"828\">Username:<\/strong> Your MySQL database username<\/span><\/li>\n<li data-section-id=\"u6lpto\" data-start=\"858\" data-end=\"902\"><span style=\"color: #000000;\"><strong data-start=\"860\" data-end=\"873\">Password:<\/strong> Your MySQL database password<\/span><\/li>\n<li data-section-id=\"1lt1txg\" data-start=\"903\" data-end=\"940\"><span style=\"color: #000000;\"><strong data-start=\"905\" data-end=\"914\">Port:<\/strong> 3306 (default MySQL port)<\/span><\/li>\n<\/ul>\n<p data-start=\"942\" data-end=\"984\"><span style=\"color: #000000;\">Popular MySQL client applications include:<\/span><\/p>\n<ul data-start=\"985\" data-end=\"1070\">\n<li data-section-id=\"1nnqx69\" data-start=\"985\" data-end=\"1002\"><span style=\"color: #000000;\">MySQL Workbench<\/span><\/li>\n<li data-section-id=\"vrujvh\" data-start=\"1003\" data-end=\"1039\"><span style=\"color: #000000;\">phpMyAdmin (if available remotely)<\/span><\/li>\n<li data-section-id=\"9ofbbf\" data-start=\"1040\" data-end=\"1049\"><span style=\"color: #000000;\">DBeaver<\/span><\/li>\n<li data-section-id=\"1xcu2q7\" data-start=\"1050\" data-end=\"1060\"><span style=\"color: #000000;\">HeidiSQL<\/span><\/li>\n<li data-section-id=\"gteyvi\" data-start=\"1061\" data-end=\"1070\"><span style=\"color: #000000;\">Navicat<\/span><\/li>\n<\/ul>\n<p data-start=\"1072\" data-end=\"1177\" data-is-last-node=\"\" data-is-only-node=\"\"><span style=\"color: #000000;\">Once the correct credentials are entered, you should be able to access and manage your database remotely.<\/span><\/p>\n<h2><span style=\"color: #000000;\">Steps to Remove host access<\/span><\/h2>\n<p><span style=\"color: #000000;\">When you don\u2019t want a host to access your MySQL databases remotely, you can remove them by performing following steps :<\/span><\/p>\n<p><span style=\"color: #000000;\">1. Log in to cPanel.<\/span><\/p>\n<p><span style=\"color: #000000;\">2. On the cPanel home screen in the Databases section, click on Remote MySQL.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-12175\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA.webp\" alt=\"how-to-configure-remote-mysql-access-in-cpanel\" width=\"1909\" height=\"894\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA.webp 1909w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA-300x140.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA-1024x480.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA-768x360.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/RDA-1536x719.webp 1536w\" sizes=\"(max-width: 1909px) 100vw, 1909px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">3. Under the <strong>Manage Access Hosts<\/strong> option, identify the host for which you want to remove the access, and then click on <strong>Delete.<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12178\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/deleteee.webp\" alt=\"how-to-configure-remote-mysql-access-in-cpanel\" width=\"1919\" height=\"893\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/deleteee.webp 1919w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/deleteee-300x140.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/deleteee-1024x477.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/deleteee-768x357.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/deleteee-1536x715.webp 1536w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">4. Click on <strong>Remote Access Host<\/strong>.\u00a0 cPanel will remove the host.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12179\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/remove-1.webp\" alt=\"how-to-configure-remote-mysql-access-in-cpanel\" width=\"1909\" height=\"893\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/remove-1.webp 1909w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/remove-1-300x140.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/remove-1-1024x479.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/remove-1-768x359.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/remove-1-1536x719.webp 1536w\" sizes=\"(max-width: 1909px) 100vw, 1909px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>When Should You Use Remote MySQL Access?<\/h2>\n<p>Remote MySQL Access is useful when:<\/p>\n<ul>\n<li>Managing databases from a local computer<\/li>\n<li>Connecting external applications<\/li>\n<li>Developing across multiple servers<\/li>\n<li>Integrating cloud services<\/li>\n<li>Supporting distributed applications<\/li>\n<\/ul>\n<p>However, if your application and database reside on the same server, local connections are generally faster and more secure.<\/p>\n<h2>Benefits of Remote MySQL Access<\/h2>\n<p>Enabling Remote MySQL Access provides several advantages:<\/p>\n<p>Improved Flexibility<\/p>\n<p>Easier Database Management<\/p>\n<p>Application Integration<\/p>\n<p>Development and Testing<\/p>\n<h2>Conclusion<\/h2>\n<p>Configuring Remote MySQL Access in cPanel is a straightforward process that enables secure communication between external applications and your MySQL databases. By carefully authorizing trusted hosts and following security best practices, you can manage and access your databases from virtually anywhere.<\/p>\n<p>Whether you&#8217;re a developer, system administrator, or website owner, understanding how to configure Remote MySQL Access can significantly improve your workflow and database management capabilities.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Configure Remote MySQL Access in cPanel Managing databases efficiently is essential for website owners, developers, and businesses. While most websites access their databases locally, there are situations where you may need to connect to a MySQL database from a remote server or application. This is where Remote MySQL Access in cPanel becomes useful. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":12180,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,1],"tags":[],"class_list":["post-12167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel","category-latest-updates"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/12167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=12167"}],"version-history":[{"count":4,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/12167\/revisions"}],"predecessor-version":[{"id":12598,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/12167\/revisions\/12598"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/12180"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=12167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=12167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=12167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}