10 ms·
Does anyone still use this? I didn't realize this was still actively maintained.
by smaili 10y ago
Does anyone still use this? I didn't realize this was still actively maintained.
- donjh 10y agoCountless people maintaining WordPress sites do.
- drzaiusapelord 10y agoEvery Drupal dev shop we've worked this insisted this was installed on the server. Its just firewalled off/tunneled/whatever for safety.
- creshal 10y agoIf you are using MySQL, and need to manually fuck around with tables for whatever reason, it's really useful and beats most other options. For us it sees plenty of use with poorly developed legacy software (e.g. Wordpress).
- martinczerwi 10y agoYou might like this: https://www.dbninja.com/ https://www.dbninja.com/
- pinum 10y agoI can't think of much reason to use it over Workbench or Sequel Pro.
- bowlich 10y agoSequel Pro - No native linux support Workbench - Massively unstable on linux. (Although I do like the visualizing tools assuming I'm willing to put up with it crashing every hour or so).
- whatsamattayou 10y agoSome dev environments aren't local, and sometimes this is faster, especially if you have to document the changes for future updates that don't include your fancy tools.
- creshal 10y agoOh, if only were we using it only in dev environments…
- markplindsay 10y agoSequel Pro's built-in SSH tunnel has worked for me in every remote development situation I've encountered. It seems like a really bad idea to place a web-based database tool on a public-facing host when technology exists to route MySQL through SSH. Even shared hosts support SSH these days. If yours doesn't, maybe it's time to find another shared host!
- smhenderson 10y agoIt's been a while but I'm pretty sure you can do so with PHPMyAdmin. I seem to remember installing it on my own workstation, setting up the ssh tunnel and then pointing PHPMA to localhost. It's not my favorite tool and I've avoided it due to security concerns but I've set it up for others as described and I recall it worked fine. Like I said though it's been a while and I'm fuzzy on the details.
- knowaveragejoe 10y agoWorkbench has some great features that I can't do without, but when it comes to just browsing around a DB I much prefer PhpMyAdmin's interface over it. That said I haven't really tried any of the other offerings in the space, so I expect that's a big part of my opinion.
- exclusiv 10y agoI agree with this comparison but Navicat is well worth the price. I use their data backup and synchronization (data and/or structure) all the time and it works extremely well. The "find in database" text search is a life saver too.
- onion2k 10y agoIf you need to make a manual database change then Adminer is often a better option[1]. It's doesn't have the featureset as PHPMyAdmin but it has a huge advantage in that it's a single PHP file you can upload, make the necessary changes, and then delete. If you're interested in maintaining a secure server but you don't have any better options than using a script, then it's better to upload something when you need it than trying to secure an online admin tool. [1] https://www.adminer.org/ https://www.adminer.org/
- creshal 10y ago> It's doesn't have the featureset as PHPMyAdmin but it has a huge advantage in that it's a single PHP file you can upload, make the necessary changes, and then delete The days of painfully slow FTP servers are long gone where "it's one file" would count as advantage. This leaves a massively worse UX and featureset. (We are using adminer for postgresql databases, because there's no better alternative, and it makes me wish phpmyadmin supported postgres every time I have to use it.)
- onion2k 10y agoHaving a single file isn't an advantage from a speed perspective; the advantage lies in only having to upload a file, make a change and delete the file again. There's no install, no config, etc.
- deleted 10y ago[deleted]
- ivanceras 10y agoDidn't postgresql community just annouced pgadmin4 lately and it seems to come with a modern webclient https://www.pgadmin.org/ https://www.pgadmin.org/
- ZenoArrow 10y agoDo any of these web-based DB tools come with autocomplete? I'd say that's the feature I value most when using desktop DB tools.
- overcast 10y agoMySQL Workbench works fine though?
- LeonM 10y ago+1 for this. The profiler (visual explain) of queries in MySQL workbench is a godsend. Also, for general querying and table layout lookup in OSX (macOS, whatever) I recommend Sequel Pro. It has a slightly better UI when working with multiple databases (easier to switch).
- bowlich 10y agoLast time I tried it (about two years ago). It would crash all the time on Ubuntu. Went back to PHPMyAdmin.
- overcast 10y agoMine kept crashing on Mac when viewing table information, turns out it was some old subversion plugin that integrated into the OS shell.
- waterphone 10y agoAnyone using shared hosting (e.g. most people who do web development for small businesses) does.
- toxican 10y agoI think many (most?) web developers get their start on some shared hosting provider where your only obvious option for managing MySQL databases is phpmyadmin. You have to dig a little deeper to realize you cna use MySQL Workbench, but even then a lot of them disable remote MySQL and SSH so you're SOL. So for me, at least, it's ingrained in my head that phpmyadmin is the best tool for the job given the limitations of what I've got. Although I recently switched my company's reseller hosting account to a provider that actually allows remote MySQL or SSH, so that's exciting.
- 20years 10y agoI personally use Workbench when I can but a lot of clients with shared hosting use it. It still gets the job done for the most part.
- blowski 10y agoIt usually comes by default with CPanel and Plesk on web servers, as well as MAMP / WAMP / XAMPP for development environments. In my experience it's still used a lot by junior devs who haven't yet learned any different, and people with absolutely no idea what they're doing.
- 23andwalnut 10y agoWhat are some good alternatives? I've been using DataGrip the last couple of months, but prior to that I used phpMyAdmin all the time because I just couldn't find anything else as useful for MySQL. And even with DataGrip, I sometimes have to log in to phpmyadmin because there's stuff DataGrip doesn't do....
- acomjean 10y agoYes. A lot of times its available on shared hosting behind some login. Esp, if you don't have shell access on inexpensive hosts. Its been available at places I've worked. It was locked down by IP. The database was restricted to access by ip too, in theory making outside access more difficult. I used it a lot (less now) and honestly, I kind of like it. The interface is a little kludgy, but it gets the job done. Queries are editable, exportable in various formats. You can construct a search via gui then edit the SQL it generates . It seems to have a lot of functionality built in, user/table management etc.. For local instances I use sequel pro too (the ssh login function it has is nice and works well).
- hackaflocka 10y agoPHPMyAdmin is a lifesaver for newbies and those who are intimidated by the Command Line. It was for me, and I still prefer to use it when possible. I can't thank the people who created it and maintain it enough.
- callesgg 10y agoI think it is one of the best mariadb/mysql gui's out there. But to get the good stuff one has to configure it properly, and generally people don't bather configuring it. They just place the files in a folder. No other web based tool for any database that i have tried even comes close.