{"id":2520,"date":"2025-08-20T07:00:21","date_gmt":"2025-08-20T07:00:21","guid":{"rendered":"https:\/\/www.34sp.com/kb\/?p=2520"},"modified":"2025-11-24T10:13:06","modified_gmt":"2025-11-24T10:13:06","slug":"ssh-tunnelling-for-remote-database-access","status":"publish","type":"post","link":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access","title":{"rendered":"SSH tunnelling for remote database access"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access\/#Using_command_line\" >Using command line<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access\/#Using_an_application\" >Using an application<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span>Introduction<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This is a step-by-step walkthrough for using SSH tunnelling to gain access to your databases remotely. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You will need your SFTP login details for this, which can be managed according to our guide <a href=\"https:\/\/www.34sp.com\/kb\/how-to-manage-your-ftp-access-details\">here<\/a>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Using_command_line\"><\/span>Using command line<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading\">STEP 1<br>Open your SSH client<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have your login credentials you will need to use a terminal application such as Command Prompt for Windows or Terminal for Mac. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To find Command Prompt on your Windows computer, press <code>Windows key + r<\/code> then type in <code>cmd<\/code> and hit ok which will launch the application, or search terminal in the Finder Utility on a Mac.<\/p>\n<\/div>\n<\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"72\" src=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2.png\" alt=\"\" class=\"wp-image-2521\" srcset=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2.png 512w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2-300x42.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading\">STEP 3<br>Login to the database<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">From here you can use two commands, if you know the login information for your database you can use a mysql command <code>mysql -u YourUsername -p DatabaseName<\/code> and input the database password when prompted, or if it\u2019s a WordPress website, step into httpdocs using <code>cd httpdocs<\/code> and run <code>wp db cli<\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading\">STEP 4<br>Run your commands<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">From here you can use any mysql commands such as <code>show tables;<\/code> to view all the tables in the database, when done you can type quit to exit the mysql command line.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Using_an_application\"><\/span>Using an application<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading\">STEP 1<br>Download your database application<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Download your database application (if not already downloaded) for example, we will be using: <a href=\"https:\/\/dbeaver.io\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/dbeaver.io\/download\/<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1006\" height=\"760\" src=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.25.52.png\" alt=\"\" class=\"wp-image-2522\" srcset=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.25.52.png 1006w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.25.52-300x227.png 300w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.25.52-768x580.png 768w\" sizes=\"auto, (max-width: 1006px) 100vw, 1006px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading\">STEP 2<br>Create a connection<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Once installed and setup, open the application and on the Database navigator section right click > Create > Connection<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1010\" height=\"792\" src=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.27.25.png\" alt=\"\" class=\"wp-image-2523\" srcset=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.27.25.png 1010w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.27.25-300x235.png 300w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.27.25-768x602.png 768w\" sizes=\"auto, (max-width: 1010px) 100vw, 1010px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading\">STEP 3<br>Select MySQL.<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">From the list of available databases, select the &#8216;MySQL&#8217; option.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"996\" height=\"936\" src=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.27.34.png\" alt=\"\" class=\"wp-image-2524\" srcset=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.27.34.png 996w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.27.34-300x282.png 300w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.27.34-768x722.png 768w\" sizes=\"auto, (max-width: 996px) 100vw, 996px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading\">STEP 4<br>Enter your database connection information<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">On the net page you can fill in your database access details. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Set the server host to <code>127.0.0.1<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once filled in click on the SSH tab and tick &#8216;Use SSH tunnel&#8217;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can now fill in additional information, this will be for your SFTP user login, set either your domain name or the hosting IP address as the Host, have authenticate method on password then enter in the username and password, do make sure the SFTP lock is unlocked if applicable via the control panel <a href=\"https:\/\/account.34sp.com\">https:\/\/account.34sp.com<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1070\" height=\"742\" src=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.28.40.png\" alt=\"\" class=\"wp-image-2525\" srcset=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.28.40.png 1070w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.28.40-300x208.png 300w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.28.40-1024x710.png 1024w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.28.40-768x533.png 768w\" sizes=\"auto, (max-width: 1070px) 100vw, 1070px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h5 class=\"wp-block-heading\">STEP 4<br>Test your connection.<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">When your details are filled in, you can use the test connection to make sure it can connect, if so save the details and in the same panel you should now see the database name, click on that and it will connect to the hosting server and open the database.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"616\" src=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.31.49.png\" alt=\"\" class=\"wp-image-2526\" srcset=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.31.49.png 1080w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.31.49-300x171.png 300w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.31.49-1024x584.png 1024w, https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/Screenshot-2025-07-02-at-08.31.49-768x438.png 768w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction This is a step-by-step walkthrough for using SSH tunnelling to gain access to your databases remotely. You will need your SFTP login details for this, which can be managed&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[217,216],"class_list":["post-2520","post","type-post","status-publish","format-standard","hentry","category-wordpress-hosting","tag-disk-space","tag-storage-space"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SSH tunnelling for remote database access | Knowledge Base<\/title>\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.34sp.com/kb\/ssh-tunnelling-for-remote-database-access\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SSH tunnelling for remote database access | Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"Introduction This is a step-by-step walkthrough for using SSH tunnelling to gain access to your databases remotely. You will need your SFTP login details for this, which can be managed...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/34SPWebsiteHosts\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/34SPWebsiteHosts\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-20T07:00:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-24T10:13:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"72\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Kayleigh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@34sp\" \/>\n<meta name=\"twitter:site\" content=\"@34sp\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kayleigh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access\"},\"author\":{\"name\":\"Kayleigh\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#\\\/schema\\\/person\\\/daa527106d35aab27ee3d39e12112172\"},\"headline\":\"SSH tunnelling for remote database access\",\"datePublished\":\"2025-08-20T07:00:21+00:00\",\"dateModified\":\"2025-11-24T10:13:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access\"},\"wordCount\":392,\"publisher\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.34sp.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/unnamed-2.png\",\"keywords\":[\"disk space\",\"storage space\"],\"articleSection\":[\"WordPress Hosting\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access\",\"url\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access\",\"name\":\"SSH tunnelling for remote database access | Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.34sp.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/unnamed-2.png\",\"datePublished\":\"2025-08-20T07:00:21+00:00\",\"dateModified\":\"2025-11-24T10:13:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access#primaryimage\",\"url\":\"https:\\\/\\\/www.34sp.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/unnamed-2.png\",\"contentUrl\":\"https:\\\/\\\/www.34sp.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/unnamed-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/ssh-tunnelling-for-remote-database-access#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kb.34sp.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSH tunnelling for remote database access\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#website\",\"url\":\"https:\\\/\\\/kb.34sp.com\\\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kb.34sp.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#organization\",\"name\":\"34SP.com Limited\",\"url\":\"https:\\\/\\\/kb.34sp.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/kb.34sp.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/34sp-logo-horizontal-blue.png\",\"contentUrl\":\"https:\\\/\\\/kb.34sp.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/34sp-logo-horizontal-blue.png\",\"width\":3000,\"height\":1286,\"caption\":\"34SP.com Limited\"},\"image\":{\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/34SPWebsiteHosts\\\/\",\"https:\\\/\\\/x.com\\\/34sp\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kb.34sp.com\\\/#\\\/schema\\\/person\\\/daa527106d35aab27ee3d39e12112172\",\"name\":\"Kayleigh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cee8c3564bca088c8f3300447726634e7e34d11b2002b3de29996ba4da754343?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cee8c3564bca088c8f3300447726634e7e34d11b2002b3de29996ba4da754343?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cee8c3564bca088c8f3300447726634e7e34d11b2002b3de29996ba4da754343?s=96&d=mm&r=g\",\"caption\":\"Kayleigh\"},\"description\":\"As part of the Customer Experience team, Kayleigh ensures that all of our customers get the highest quality of service. Kayleigh started with 34SP in 2014 and is one of our WordPress experts. Kayleigh provides all of our support staff with ongoing training and works to improve their knowledge across a broad range of subjects.\",\"sameAs\":[\"https:\\\/\\\/www.34SP.com\",\"https:\\\/\\\/www.facebook.com\\\/34SPWebsiteHosts\",\"https:\\\/\\\/www.instagram.com\\\/34sp\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/34sp.com\",\"https:\\\/\\\/www.pinterest.co.uk\\\/34SP\",\"https:\\\/\\\/x.com\\\/34sp\",\"https:\\\/\\\/www.youtube.com\\\/c\\\/34SPcomLtd\"],\"url\":\"https:\\\/\\\/kb.34sp.com\\\/author\\\/wp7ctmdod3qm\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSH tunnelling for remote database access | Knowledge Base","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.34sp.com/kb\/ssh-tunnelling-for-remote-database-access","og_locale":"en_US","og_type":"article","og_title":"SSH tunnelling for remote database access | Knowledge Base","og_description":"Introduction This is a step-by-step walkthrough for using SSH tunnelling to gain access to your databases remotely. You will need your SFTP login details for this, which can be managed...","og_url":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access","article_publisher":"https:\/\/www.facebook.com\/34SPWebsiteHosts\/","article_author":"https:\/\/www.facebook.com\/34SPWebsiteHosts","article_published_time":"2025-08-20T07:00:21+00:00","article_modified_time":"2025-11-24T10:13:06+00:00","og_image":[{"width":512,"height":72,"url":"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2.png","type":"image\/png"}],"author":"Kayleigh","twitter_card":"summary_large_image","twitter_creator":"@34sp","twitter_site":"@34sp","twitter_misc":{"Written by":"Kayleigh","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access#article","isPartOf":{"@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access"},"author":{"name":"Kayleigh","@id":"https:\/\/www.34sp.com/kb\/#\/schema\/person\/daa527106d35aab27ee3d39e12112172"},"headline":"SSH tunnelling for remote database access","datePublished":"2025-08-20T07:00:21+00:00","dateModified":"2025-11-24T10:13:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access"},"wordCount":392,"publisher":{"@id":"https:\/\/www.34sp.com/kb\/#organization"},"image":{"@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access#primaryimage"},"thumbnailUrl":"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2.png","keywords":["disk space","storage space"],"articleSection":["WordPress Hosting"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access","url":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access","name":"SSH tunnelling for remote database access | Knowledge Base","isPartOf":{"@id":"https:\/\/www.34sp.com/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access#primaryimage"},"image":{"@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access#primaryimage"},"thumbnailUrl":"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2.png","datePublished":"2025-08-20T07:00:21+00:00","dateModified":"2025-11-24T10:13:06+00:00","breadcrumb":{"@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access#primaryimage","url":"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2.png","contentUrl":"https:\/\/www.34sp.com\/kb\/wp-content\/uploads\/2025\/07\/unnamed-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.34sp.com/kb\/ssh-tunnelling-for-remote-database-access#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.34sp.com/kb\/"},{"@type":"ListItem","position":2,"name":"SSH tunnelling for remote database access"}]},{"@type":"WebSite","@id":"https:\/\/www.34sp.com/kb\/#website","url":"https:\/\/www.34sp.com/kb\/","name":"","description":"","publisher":{"@id":"https:\/\/www.34sp.com/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.34sp.com/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.34sp.com/kb\/#organization","name":"34SP.com Limited","url":"https:\/\/www.34sp.com/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.34sp.com/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.34sp.com/kb\/wp-content\/uploads\/2022\/06\/34sp-logo-horizontal-blue.png","contentUrl":"https:\/\/www.34sp.com/kb\/wp-content\/uploads\/2022\/06\/34sp-logo-horizontal-blue.png","width":3000,"height":1286,"caption":"34SP.com Limited"},"image":{"@id":"https:\/\/www.34sp.com/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/34SPWebsiteHosts\/","https:\/\/x.com\/34sp"]},{"@type":"Person","@id":"https:\/\/www.34sp.com/kb\/#\/schema\/person\/daa527106d35aab27ee3d39e12112172","name":"Kayleigh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/cee8c3564bca088c8f3300447726634e7e34d11b2002b3de29996ba4da754343?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/cee8c3564bca088c8f3300447726634e7e34d11b2002b3de29996ba4da754343?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cee8c3564bca088c8f3300447726634e7e34d11b2002b3de29996ba4da754343?s=96&d=mm&r=g","caption":"Kayleigh"},"description":"As part of the Customer Experience team, Kayleigh ensures that all of our customers get the highest quality of service. Kayleigh started with 34SP in 2014 and is one of our WordPress experts. Kayleigh provides all of our support staff with ongoing training and works to improve their knowledge across a broad range of subjects.","sameAs":["https:\/\/www.34SP.com","https:\/\/www.facebook.com\/34SPWebsiteHosts","https:\/\/www.instagram.com\/34sp\/","https:\/\/www.linkedin.com\/company\/34sp.com","https:\/\/www.pinterest.co.uk\/34SP","https:\/\/x.com\/34sp","https:\/\/www.youtube.com\/c\/34SPcomLtd"],"url":"https:\/\/www.34sp.com/kb\/author\/wp7ctmdod3qm"}]}},"_links":{"self":[{"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/posts\/2520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/comments?post=2520"}],"version-history":[{"count":4,"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/posts\/2520\/revisions"}],"predecessor-version":[{"id":2530,"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/posts\/2520\/revisions\/2530"}],"wp:attachment":[{"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/media?parent=2520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/categories?post=2520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.34sp.com/kb\/wp-json\/wp\/v2\/tags?post=2520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}