phpMyAdmin vs Adminer?
- Thread starter MannDude
- Start date
I am a phpMyAdmin user for a long time. Actually I started playing with databases using it. Started using adminer on servers where phpMyAdmin was not installed almost an year ago and I am happy with it. For development environment, I have both, as phpMyAdmin can be handy in editing single fields. On servers I mostly run sql queries or check the table structure or even take a dump, for which adminer is more than enough.
Licensecart
Active Member
I've always used PhpMyAdmin simply because it's easy to use and looks nice. Adminer just checked the website out and the design is basic, but if it had a nice UI would be a good competitor the only good thing so far is it's just one file. But yeah PhpMyAdmin gets my vote.
AuroraZero
Active Member
I have started using Adminer more and more. I believe it gives more control to you. Sometimes PhPMyAdmin will not do the job I ask it do. If a server does not have Adminer I install it and use it instead. Seems like it can recover some things that PhPMyAdmin can not as well, at least from my tests with it, it was able.
To be honest I hadn't heard of Adminer until this thread, just checked them out and it looks quite displeasing to the eye... I know I know, looks != quality, but still...
And to answer the question, I've always found phpMyAdmin to do everything I ever needed from a mysql interface, never actually felt the need to look for something else or something different.
And to answer the question, I've always found phpMyAdmin to do everything I ever needed from a mysql interface, never actually felt the need to look for something else or something different.
Aldryic C'boas
The Pony
I always found dealing with "managers" to be more of a PITA than good ol' mysql-client, honestly. Never did understand the appeal of wading through GUI options and menus to run a two-line command.
But since we are discussing managers - no love for Navicat/etc? There's a handful of pretty decent 'local' mySQL management tools that simply connect to the remote DB in question.
But since we are discussing managers - no love for Navicat/etc? There's a handful of pretty decent 'local' mySQL management tools that simply connect to the remote DB in question.
DomainBop
Dormant VPSB Pathogen
Adding a piece of software with one of the worst security track records in recorded history to your system seems like it could potentially be a bigger pain in the ass than using CLI. 154 security bulletins, an average of 11 per year over the past 14 years for phpMyAdmin.
http://www.cvedetails.com/vulnerability-list/vendor_id-784/Phpmyadmin.html
If I used a GUI tool I'd pick AdMiner over phpMYAdmin on the basis of its better security track record over the years.
MySQL Workbench Community Edition is another alternative...and it's free. Linux/Mac/Windows versions.Quote said:
DBeaver is another database management tool: free, multiplatform, and supports just about every database around:
Quote said:
its hard to argue the history of security disasters that phpmyadmin has presented for years - but its simplicity has made it a front runner for so long.
Adminer made a comparison about why they are better than phpmyadmin. You could take a look about their plus (and minus) in http://www.adminer.org/en/phpmyadmin/
Last edited by a moderator:
wlanboy
Content Contributer
I am using the portable version of HeidiSQL: http://www.heidisql.com/
Supports SSH tunnels for MySQL connections. Loving the grid editor too.
Supports SSH tunnels for MySQL connections. Loving the grid editor too.
VPSSoldiers
New Member
MySQL Workbench also supports ssh tunnelling, such a great feature.
Gang Starr
New Member
If you need a on server solution I'd use phpMyAdmin - simply the best. Otherwise if you have remote connection enabled I'd use HeidiSQL. Works great and quite handy.
