Live data from Hacker News

Bike - phpMyAdmin replacement for geeks

webcheatsheet.com

21–30 of 47 posts

Re: Bike - phpMyAdmin replacement for geeks

#21

I realize that this is a totally different strategy to solve the mySQL admin thing, but WOW is Sequel Pro great if you're on a Mac: http://www.sequelpro.com/ I used phpMyAdmin for 10 _years_, and switched after using Sequel Pro for 5 minutes.

I can fully recommend it too. Now I shudder whenever I have to use phpmyadmin.

Re: Bike - phpMyAdmin replacement for geeks

#22
post #9

There is no need for this software to exist. No need. No need for it to exist.

FWIW, I've got (or have to deal with) several ultra-inexpensive webhosting accounts where I don't get shell access, so command line mysql isn't an available option.

Every one of these kind of accounts I've got, and the ones I'm happy to help friends out with, are all cpanel accounts, so I've pretty much always got phpmyadmin available.

I'm not saying Bike (or phpmyadmin) are a good idea - but I do have a need for something like it to exist.

(Arguably, if this software _didn't_ exist, webhosting companies would maybe give shell more readily to even the lowest of low-end hosting accounts, but that's not the reality I live in right now.)

Re: Bike - phpMyAdmin replacement for geeks

#23
post #6

The issue behind phpMyAdmin IMHO neither is the fact that it's written in PHP nor that it looks unsexy. The problem is that it exists. It's too tempting to leave it running on some server and promptly forget it. Or get it installed without knowing by some third-party CMS. Even if it had a spotless security track record (it doesn't), this is just too big an attack surface. MySQL and especially Postgres have really goo…

Agreed, seen time and time again how this has become a liability for clients.

I either command line in over SSH or open up a tunnel and use SQLYog.

Re: Bike - phpMyAdmin replacement for geeks

#24

If you go to their github page it says the following under security: "On current stage I don't care about login functionality. Put Bike into folder with name like 'tASTDKUWYVEjhas' or just use Apache httpauth as workaround." So basically... they have absolutely nothing built in for security, other than hoping you choose a good folder name. Even if you ignore that, this is an all-around poor attempt to be an alternati…

"So basically... they have absolutely nothing built in for security …"

So I wonder how long before this becomes a trending search query?

https://www.google.com.au/search?q=inurl%3A%2Fbike+%22Run+Qu...

(a slightly more refined version of that search, which I'll leave as an exercise for the reader, has already revealed 3 probably exploitable urls, based on the google snippet - I'm not prepared to click the links to confirm…)

While I can understand the author writing a tool that scratches his own itch, where that itch doesn't include the need for strong access control for the tool - releasing it in a "default unsafe" configuration seems, ummmm, unwise. I'd suggest perhaps publishing the software with a hardcoded 10..1 ip address as the only address it'll respond to, so that you can't just download and run it with the result of a wide-open access to your databases. If someone's savvy enough to safely use the tool, updating that hardcoded ip address to their own will be obvious, and while opening it up to the world will still be _possible_, at least it'll require some intentional effort.

Re: Bike - phpMyAdmin replacement for geeks

#25
post #19
post #6

The issue behind phpMyAdmin IMHO neither is the fact that it's written in PHP nor that it looks unsexy. The problem is that it exists. It's too tempting to leave it running on some server and promptly forget it. Or get it installed without knowing by some third-party CMS. Even if it had a spotless security track record (it doesn't), this is just too big an attack surface. MySQL and especially Postgres have really goo…

So wouldn't you just setup a simple secure tunnel and run this on your local dev machine (with key-auth and an ssh agent to manage the connections)? That's how I run my phpAdmin. No server security issues.

That of course works too, but then again, I wonder what features of phpMyAdmin warrant the overhead of actually installing it plus the webserver it needs as opposed to just using the mysql command line tool (honest question - I haven't been using MySQL in a long time and on Postgres' side there's nothing that a GUI would allow me to do quicker than what I can do in the CLI psql utility)

Re: Bike - phpMyAdmin replacement for geeks

#26
post #19
post #6

The issue behind phpMyAdmin IMHO neither is the fact that it's written in PHP nor that it looks unsexy. The problem is that it exists. It's too tempting to leave it running on some server and promptly forget it. Or get it installed without knowing by some third-party CMS. Even if it had a spotless security track record (it doesn't), this is just too big an attack surface. MySQL and especially Postgres have really goo…

So wouldn't you just setup a simple secure tunnel and run this on your local dev machine (with key-auth and an ssh agent to manage the connections)? That's how I run my phpAdmin. No server security issues.

Yep, but if you do that you may as well use something like MySQL Workbench, which is fucking awesome, or pgAdmin III, which is okay.

Re: Bike - phpMyAdmin replacement for geeks

#27

If you go to their github page it says the following under security: "On current stage I don't care about login functionality. Put Bike into folder with name like 'tASTDKUWYVEjhas' or just use Apache httpauth as workaround." So basically... they have absolutely nothing built in for security, other than hoping you choose a good folder name. Even if you ignore that, this is an all-around poor attempt to be an alternati…

The two simple ways of addressing this are to use some sort of folder level authentication (e.g. htaccess and htpasswd or equivalent) and to make sure it's not referenced in sitemaps or robots.txt, nor linked to from elsewhere on the net.

Re: Bike - phpMyAdmin replacement for geeks

#28

I realize that this is a totally different strategy to solve the mySQL admin thing, but WOW is Sequel Pro great if you're on a Mac: http://www.sequelpro.com/ I used phpMyAdmin for 10 _years_, and switched after using Sequel Pro for 5 minutes.

This means you have to have your mysql port opened? No thank you

Re: Bike - phpMyAdmin replacement for geeks

#29

I realize that this is a totally different strategy to solve the mySQL admin thing, but WOW is Sequel Pro great if you're on a Mac: http://www.sequelpro.com/ I used phpMyAdmin for 10 _years_, and switched after using Sequel Pro for 5 minutes.

This means you have to have your mysql port opened? No thank you

Re: Bike - phpMyAdmin replacement for geeks

#30

I realize that this is a totally different strategy to solve the mySQL admin thing, but WOW is Sequel Pro great if you're on a Mac: http://www.sequelpro.com/ I used phpMyAdmin for 10 _years_, and switched after using Sequel Pro for 5 minutes.

Sequel pro is such a good bit of software, especially for the price. I fell in love after a couple of days, and even if you're not looking for new mysql software it's worth a look to see how well the UX has been implemented. The most useful thing about it is you can jump between the various views it offers, across multiple tables, and it maintains the state of each view so well that it's an absolute pleasure to use.
Post reply on HN