From phpMyAdmin Development Team:
phpMyAdmin is intended to handle the adminstration of MySQL over the web. Create and drop databases. Create, copy, drop and alter tables. Delete, edit and add field. Execute any SQL-statement, even batch-queries. Manage keys on fields. Load text files into tables. Create and read dumps of tables. Export data to CSV values. Administer multiple servers and single databases.
This review was originally posted on VersionTracker.com. I'm mainly writing this to offset the other person's opinion that phpMyAdmin is difficult to set up or that it doesn't work.
The truth is that if you are at all familiar with PHP and SQL this is a breeze to set up. It requires rock bottom beginner level understanding of both to setup and even less to use. It works very well and improves greatly with each version. phpMyAdmin is used by tons of web hosts because it is so easy to use.
This review was originally posted on VersionTracker.com. ... if you think you can use this product without sweat and tears. The docs are only there to make you go crazy from the very start. Simply installing the thing in order to test it is a challenge by itself (unless you're a Unix geek of course). Instead of just telling you what's required and how to install, they make you go back and forth for hours and in the end it doesn't work anyway. I'll stick to CocoaMysql.
This review was originally posted on VersionTracker.com. Could the fonts, button, pulldowns, etc. be any bigger?
What happened to this thing? It used to be great. Now the interface is completely cluttered. You need a 20" screen or you'll have to scroll sideways!
This review was originally posted on VersionTracker.com. This is very nice, and there's a lot of evolution since the last time I had to look at the manual. I hope somebody is underwriting these guys, because free doesn't seem like enough to compensate. Still eleven stars.
This review was originally posted on VersionTracker.com. This is a wonderfull solution. the direct linking to the MySQL docmuntation really helps learning and troubleshooting. Even generates PHP code for use in your website. If only they could make form generation part of the program.
This review was originally posted on VersionTracker.com. Not only does this tool let you perform just about all admin tasks (except possibly recovery, which is a good thing), the way it is tied into the MySQL documentation makes it invaluable for learning (or remembering) MySQL syntax and operations. This is a must-have for any PHP/MySQL programmer or administrator.
This review was originally posted on VersionTracker.com. phpMyAdmin is part of my "essential tools" kit. I install it on clients' machines as a matter of course. It makes working with MySQL a breeze. When you work with a number of different database servers as I do, not having to remember the details of how to set things up makes a big difference.
This review was originally posted on VersionTracker.com. I've used six or seven different database front-end apps, and I keep coming back to this. Nothing is better for managing, updating, and testing a database deployment. This definitely shows what open source software can accomplish.