How To Access Your Blog / Website Database On Your Desktop – Part I
By on July 22nd, 2008

Many web hosting providers do not use DNS to provide you access to your database, in such cases the database is only accessible by the files residing on your hosting account.

Tip: If you are using localhostas your database host, your database can only be accessed by files hosted on your web account.

There are several tools such as phpmyadmin, which will allow you to access your database through the web, but many users may still prefer to access the database from their favorite desktop client. In this post we will show you, how you can easily access database confined to your website / blog from your desktop.

The earlier host for Techie Buzz, provided us access using DNS, using which we could backup and keep tabs on it from our desktop. But since we moved to a new server, we did not have access to it and we used some of our expertise to access the database from our desktop. We are more than glad to share the same with our readers and thousands of people who read us.

Note: You will need to have SSH access to your hosting account to make full use of this tutorial, even if you don’t have one you can bookmark this for a later date when you do have SSH access.

Tools Needed

Here are a couple of tools we will be using in this tutorial so keep them handy.

  1. Tips and tricks,how to,SSH,SSH tunnels,create ssh tunnels,access remote database,remote database,tunnels tutorial
Tags: ,
Author: Keith Dsouza Google Profile for Keith Dsouza
I am the editor-in-chief and owner of Techie Buzz. I love coding and have contributed to several open source projects in the past. You can know more about me and my projects by visiting my Personal Website. I am also a social networking enthusiast and can be found active on twitter, you can follow Keith on twitter @keithdsouza. You can click on my name to visit my Google+ profile.

Keith Dsouza has written and can be contacted at

Leave a Reply

Name (required)

Website (optional)

Copyright 2006-2012 Techie Buzz. All Rights Reserved. Our content may not be reproduced on other websites. Content Delivery by MaxCDN