Overview
A software tool to bring MySQL to the Web
Read MorephpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement, manage indexes on columns.
Features
- Intuitive web interface
- Support for most MySQL features
- Import data from CSV and SQL
- Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LATEX and others
- Administering multiple servers
- Creating PDF graphics of your database layout
- Creating complex queries using Query-by-example (QBE)
- Searching globally in a database or a subset of it
- Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
- And much more...
Reviews (144)
Write a ReviewHighest Rated
It makes my everyday work much easier. Thanks !
Lowest Rated
I loved phpMyAdmin before they ruined everything with popups ant sh*t (new design solutions)! now its a true challange and nightmare to work with :( but sadly there is no better tool, even when its so annoying to use. imagine creating a table with 20 fields and 3rd time in a row after filling almost all inputs you hit ESC to cancel browser autocomplete and you have to start all over again because popup is closed :( and if thats not enough after you fill 20 field form again for the 4th time you get alert "This is not a number" with no sign what does it mean by saying "This", you have to refresh the page and start all over again! i'm so furious with this new update, and lots of my friends who have to use this newly designed phpMyAdmin just hates it :(
)
Good as a management tool, very poor for writing and executing queries because there's just too much web-based clutter. A much-needed improvement would be a proper console (not the 'console' they are currently developing) with results appearing in tabbed areas - much like SQLyog, PhpStorm's database console or MySqlWorkbench.
Used to be a pretty fast tool. Since the usage of ajax it behaves like a shot turtle. Accidentally double clicking a record with a CURRENT TIMESTAMP setting, changes that date. Not all 'improvements' are just that ... Looking for an alternative
Must-have tool for web-based database administration tasks. Would maybe need some interface enhancements to catch up with the modern web (or at least maybe a modern theme with modern features, to keep all the vanilla users happy as well).
The good thing about phpmyadmin is that developers implement new features or new mysql/mariadb functionality support much faster than desktop apps like sqlyog because developers release new versions often.
Resources
Add-ons & Plugins
