phpMyAdmin devel team - (Freeware)
phpMyAdmin is one of the most known software tools for the MySQL database administration.
phpMyAdmin is an open source database management system for MySql databases. phpMyAdmin has an intuitive and customizable interface that allows to create, copy, and move any database, edit the tables and fields, execute a SQL query, manage keys and privileges or to easily and ergonomically . It is a clear, simple and above all functional interface that allows beginners to manage virtual database (inserts, updates, and any other changes to databases).
phpMyAdmin supports the formulation of queries directly in SQL saving precious time. It also allows the management of MySQL users and privileges and the stored procedures and triggers.Export data to various formats like CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LATEX and others can be easily made being a very useful feature.
- Error using UNION query
- Transformations overview not reachable
- Js freezes in the management of replication
- Query fails when using aliases after ordering result
- Adding columns in table creation clears existing columns
- Requires wildcard EXECUTE/ALTER ROUTINE on DB to allow Procedures to be executed by user
- Adding a column when creating a table does not propagate index info
- Unable to execute create procedure statement from query window