Connecting to database via PHPMyAdmin

dreadnaut's profile image dreadnaut posted 4 years ago in Feature discussion Permalink

There are a number of cheap hosting services that offer MySQL databases, which can only be administered via PHPMyAdmin. No direct connections, no SSH access. I have dreamt of using HeidiSQL to access my data.

Would it be possible to add a new "Network type", something like "MySQL (via PHPMyAdmin)", which logs in and relays commands to an installation of PHPMyAdmin? Alternatively, it would be possible to write a custom proxy in PHP, which could probably offer a cleaner interface, and one that we control.

I'm ready to put some C++ skills at work here, and a lot of PHP experience, to help make this happen.

(previously)

ansgar's profile image ansgar posted 4 years ago Permalink

See also this last thread regarding HTTP tunneling.

I think that "PHPMyAdmin proxy" is a broken idea. You have two applications in various versions lying around, and the user will be left alone when one of the applications has a bug. At least this is going to break more often than a SSH tunnel connection (which is already broken sometimes).

HeidiSQL is written in Delphi, by the way.

dreadnaut's profile image dreadnaut posted 4 years ago Permalink

I think that "PHPMyAdmin proxy" is a broken idea. You have two applications in various versions lying around, and the user will be left alone when one of the applications has a bug.

That is a valid concern, yes. The counterargument would be that the contact surface would be minimal (login / execute query), but the probability of something misaligning makes this a pain to maintain.

I've had a look at the discussions on the PHP proxy (including #1405 with a sample implementation). Understandably, there is not much enthusiasm for this feature :-)

Well, thanks anyway!

Please login to leave a reply, or register at first.