{"id":705,"date":"2026-03-20T11:47:12","date_gmt":"2026-03-20T11:47:12","guid":{"rendered":"https:\/\/cloudabove.com\/help\/?p=705"},"modified":"2026-03-20T11:47:12","modified_gmt":"2026-03-20T11:47:12","slug":"how-to-resolve-remote-mysql-connection-issue-after-a-server-migration","status":"publish","type":"post","link":"https:\/\/cloudabove.com\/help\/how-to-resolve-remote-mysql-connection-issue-after-a-server-migration\/","title":{"rendered":"How To Resolve Remote MySQL Connection issue after a server migration"},"content":{"rendered":"\n<p>Remote MySQL access can remain enabled in cPanel after a migration, but connections may still fail if the connecting IP address is not also allowed through the server firewall. This can affect external database tools such as desktop SQL clients.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Symptoms<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A remote database client cannot connect to MySQL on a migrated hosting server.<\/li>\n\n\n\n<li>The same static external IP address may have worked before the migration.<\/li>\n\n\n\n<li>The IP address may already be listed in cPanel under Remote Database Access for one or more accounts, but the connection still fails.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Cause<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The external IP address has not been re-added in Remote MySQL dashboard on the cPanel accounts in the new platform<\/li>\n\n\n\n<li>Firewall access for MySQL has not yet been allowed for that IP on the destination server.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Solution<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Add the external static IP address to Remote Database Access in each relevant cPanel account.<\/li>\n\n\n\n<li>Ensure the remote client is connecting to the current server hostname on the standard MySQL port.<\/li>\n\n\n\n<li>Allow the same external IP address through the server firewall for MySQL access.<\/li>\n\n\n\n<li>Retry the connection from the remote database client.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Connection settings<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>Host: &#091;server hostname]\nPort: 3306<\/code><\/pre>\n\n\n\n<p>NB: Ensure to use the current server hostname for the hosting platform and not the old hostname from before migration. If you are unsure which hostname to use, check your hosting details in my.cloudabove.com or contact support at support@cloudabove.com.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">If it still does not work<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Check that the correct external static IP address is allowlisted.<\/li>\n\n\n\n<li>If you manage multiple cPanel accounts, verify the IP has been added in each account that requires access.<\/li>\n\n\n\n<li>Confirm you are using the current server hostname and port 3306.<\/li>\n\n\n\n<li>Ask support to verify that the server firewall allows MySQL connections from your IP address.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Remote MySQL access can remain enabled in cPanel after a migration, but connections may still fail if the connecting IP address is not also allowed through the server firewall. This can affect external database tools such as desktop SQL clients. Symptoms A remote database client cannot connect to MySQL on&hellip;<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,27],"tags":[],"class_list":["post-705","post","type-post","status-publish","format-standard","hentry","category-cpanel","category-reseller"],"_links":{"self":[{"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/posts\/705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/comments?post=705"}],"version-history":[{"count":1,"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/posts\/705\/revisions"}],"predecessor-version":[{"id":706,"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/posts\/705\/revisions\/706"}],"wp:attachment":[{"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/media?parent=705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/categories?post=705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudabove.com\/help\/wp-json\/wp\/v2\/tags?post=705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}