Remote DB Access

Having trouble accessing your database remotely?

Hosting providers are among the funniest people to deal with, and I am not talking about a humerous evening I had out with a server admin one time at the bar. They are a strange breed of people much like any other class you can name outsideof “THEM”, and they are this way for a specific reason.

People trust hosting providers with a lot of data and they depend on them to keep is secure, and also to prevent the data from being inaccessible at the same time 24 hours a day, 7 days a week, 365 days a year. So naturally these people tend to be a bit uptight and set in their ways. So when you contact them asking for more access to this or that or ask them how to solve a particular problem that their platform presents for you, don&squo;t be surprised when you leave with a soar backside. It has been a long time since I have heard of db access being allowed outside the hosting server by direct port but what are the solutions for this? I mean there are about a trillion pages indexed in google, so how do each of these page sites get their data if they can not connect?

PhpMyAdmin

PhpMyAdmin has been around for some time and is one of the open source solutions available and has the benefit of not needing direct port access externally and has a nice enough interface to perform most tasks. The website for PhpMyAdmin is here and it is still actively maintained as of the time of this writing. I don&squo;t expect that to change any time soon. PhpMyAdmin is a php software package that must be installed on the server and probably should be removed thereafter db manipulation is needed. There are, however, some things to consider when attempting to think about phpMyAdmin and that is the maxupload limit of the server, the max processing time, and maxpost – see

Max Execution Time,
Max Input Time,
Max Post,
Memory Limit
Max Upload

for more details.

HTTP Tunneling

SQLyog is a specific commercial software that allows tunneling to mysql through a php connection.

ttessier

About ttessier

Professional Developer and Operator of SwhistleSoft
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *