phpMyAdmin 2.6.1 Reviews and Download

phpMyAdmin 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 fields, execute any SQL statement, manage keys on fields.

Software: Freeware

Operating Systems: Microsoft Windows, Linux

Download: phpMyAdmin 2.6.1

Homepage: phpMyAdmin

Version ChangeLog:

Upgrade note:

Using external transformations now requires PHP > 4.3.0
Improvements:
Big speed improvement (if using auth_type = 'cookie') by using the mcrypt library (if available on your system)
Improved wording when adding fields
(mysqli) support for compressed protocol and CLIENT_LOCAL_FILES
Clickable active server in left panel
Improved ANSI mode in various scripts
Hints added (light bulb)
Database copying
New Database Operations tab: note that many db operations have been moved here, including the PDF schema generation dialog
Optional simple blocking of root login
Binary log display
Index creating on multiple fields
Improved displaying of messages below tabs
Handle MySQL "duplicate entry" error
User list: top index for user initials
Support for OLD_PASSWORD() function
Under MySQL 4.1.2+, we no longer need the control user to have rights over the "mysql" db
New checks for common index problems
Upload: show filename of uploaded file
Improved page selector when browsing foreign table values
Improved handling of InnoDB constraints
Speed up display for left panel with PMA infrastructure is used
New message "no activity..."
Support of keywords NAMES and VIEW
Can now edit next entry (based on the next numeric primary key)
New warnings related to the use of mbstring
Improved navigation in calendar
Export: selectable SQL compatibility
PDF schema: added support for output in UTF-8
Fixes:
Security fix against some crafted data allowing arbitrary program execution (if PHP safe mode is off and external transformations are activated)
Security fix against a possible attack on read_dump.php (if PHP safe mode is off)
Incorrect appending of LIMIT to queries
Export: insufficient space to save
Export: convert end of line chars we get from MySQL
Wrong double column sort (with JOIN)
Export: (mysqli) some fields wrongly exported as BINARY
Illegal mix of collations for converted strings
Wrong tabbing from value to value
Allow work on temporary tables
UNIX_TIMESTAMP and optional parameter
Export: improved zip headers
0 as field name caused problems
Incorrect handling when no default server defined
Export: Use just for SQL exports
Comments and multi-table selects
Security: deactivate the list of programs for external transformations
Incorrect handling of OFFSET
Better displaying of table-specific privileges for a db containing an escaped character
Since 2.6.0-pl3, connecting on a non-standard HTTP port did not work
Do not catch Alt and Shift keys
Do not duplicate constraints when exporting multiple databases
Illegal length for LONGTEXT
Moving/copying a table: problem with constraints copying
Reloading frame on multiple queries
Collations on non-text fields
Use standardized MIME type for gzip/bzip2
Problem with field names like 000
Timestamps problem under MySQL 4.1.x
Support Option key for field moving in Safari
Error when adding a FLOAT field under MySQL 4.1.x
Headers sent on invalid login
Wrong treatment of MySQL error 1060
Problem in bookmark logic when using MySQLi