2.6.0

phpMyAdmin 2.6.0

Released 2004-09-27.

This release brought character set and MySQL 4.1 support.

About patch level 3

Version 2.6.0-pl3 fixes XSS vulnerabilities. See the PMASA-2004-3 security announcement.

About patch level 2

Version 2.6.0-pl2 fixes a security flaw that allows, on a PHP server not running in safe mode, to execute a command with the privileges of the user under which the web server is running.

About patch level 1

Version 2.6.0-pl1 fixes a problem that prevents using 2.6.0 under PHP 4.1.x and 4.2.x.

Upgrade note

If you are using MySQL 4.1.2 or later, the pmadb must be in UTF-8. See Linked-tables infrastructure in Documentation.html for a way to correctly create the pmadb, or upgrade it.

Improvements

PHP 5 mysqli extension support
- better performance
- improved security
Improved support for character sets
Support for UTF-8 databases under MySQL 4.1
Site-configurable header and footer
export:
- can add custom text to SQL export headers
- support for IF NOT EXISTS
- support for INSERT IGNORE and UPDATE IGNORE
- use unbuffered queries
- enclosing SQL export in a transaction
- selective row export
- improved ANSI compatibility
Operations: now copy table defaults to "structure and data"
Operations: database renaming
Editing: option "Go back to this page"
Sort: natural order (configurable)
Search page: DISTINCT, IS NULL, IS NOT NULL, NOT LIKE, multiple choices for ENUM
Left panel Logout link
Popup calendar (date and time editing) for date, datetime and timestamp fields
Set and alter collations for databases, tables and fields
"(Un)check all" link for privileges page
(alpha2) Optional display of server choice as links
(alpha2) Click on result row to mark the checkbox
(alpha2) Show if BLOB is NULL
(alpha2) Mouse cursor in db structure and table structure views
(alpha2) Multiple row insert
(alpha2) Search: new choice LIKE %...%
(alpha2) Can now change the number of columns when adding fields
(beta1) Graphical redesign (CSS-based) and theme management
(beta1) InnoDB table defragmentation
(beta1) Use one cookie per server
(beta1) Default query can now contain field names
(beta1) MySQL 4.1.2 support ("engine")
(beta1) Export: experimental native Ms Excel support
(beta1) Export: add FOREIGN_KEY_CHECKS=0
(beta1) Auth: catch error when server is not responding
(beta1) Operations: can now specify sort order for "Alter table order by"
(beta1) Support for SHA1 function
(beta1) Enable Relation view for InnoDB even if internal relations infrastructure is not in place
(rc1) Export: hexadecimal encoding of binary fields is now optional
(rc1) Database statistics: add collations
(rc1) Now it's possible to choose our connection character set
(rc1) Support for GROUP_CONCAT()
(rc1) Improved sort order in dropdown list of foreign values
(rc2) Support for SHOW STORAGE ENGINES and SHOW TABLE TYPES (in the parser)
(rc2) Check the privileges of the anonymous user
(rc2) Themes version number
(rc2) Search data work whatever the connection charset
(rc2) Support BINARY and VARBINARY data types
(rc2) Save chosen connection charset into a cookie
(rc2) Search: do not offer "LIKE %...%" as default because of performance issues
(rc2) Adding fields dialog: better look

Fixes

Security: Protection against cookie hijacking: encrypt also the user name, and set a time limit on the validity of encrypted password in the cookie
Error parsing floating point digit and GRANT...TO
Numeric field names
Keyword field names become capitalized
Substr transformation broken with utf-8
CONSTRAINT error in MySQL 3.23.x
MySQL charsets not added to WHERE clauses
Export:
- on-the-fly compression problem
- CSV problem with double-byte characters
- UPDATE option does not work
- (alpha2) Handling of multi-column foreign keys
Editing:
- Invalid escaping of + in ENUM
- Undefined submit_mult
- Cannot edit first row when no primary key
- Cannot edit big table structure
- Multi-edit: changes are lost
- Editing of double and float numbers
- Charset information was lost when changing fields
Invalid row count when emptying table
Error on Delete link after a db search
Interface: Icons not displayed for index management
Problem when the query contains quotes
Wrong detection of the CREATE privilege
Problem when the bookmarks table does not exist
Password error when copying a user
Search page and empty VARCHAR column
IIS crash: header problem
(alpha2) Invalid SQL on empty table export
(alpha2) Multi-byte functions and windows- charsets
(alpha2) Handling of USE in multiple queries
(alpha2) Light mode undefined indices
(alpha2) Consistent window layout for query window
(alpha2) Missing localization for multi-row edit/delete/export
(alpha2) Data dictionary: wrong formatting
(alpha2) Uploading with UploadDir and open_basedir restriction
(alpha2) Handling of complex sort queries
(alpha2) Nested mode: collapsing problem
(alpha2) Multi-edit: wrong tabindex ids
(alpha2) Calendar: maximum values
(alpha2) Privileges: wrong message when editing for non-existent db
(alpha2) Parser and multibyte strings
(alpha2) Browsing of foreign table: problem with encoding of the primary key reference
(alpha2) Cookie login: avoid double frames
(alpha2) Nested table now also works with aliases tablenames
(beta1) Nested table: wrong group expanding (foreign characters)
(beta1) Shorten query for edit/delete
(beta1) Database search: use SELECT *
(beta1) Error when deleting last row
(beta1) Vertical mode: broken row highlighting
(beta1) Better handling of MySQL comments (-- followed by any control character)
(beta1) Wrong internal encoding for Hebrew
(beta1) Ignore comments for SQL splitting
(beta1) Synchronize left frame database drop-down box (number of tables)
(beta2) Undefined index in left frame
(beta2) Undefined variable db
(beta2) Granting privileges does not take wildcards into account
(beta2) Left frame does not reload on CREATE TABLE
(beta2) Exporting and more than one foreign key
(beta2) Javascript error when changing theme
(beta2) Warning in mysql.dbi.lib.php
(beta2) During table creation, query window tries to get the list of fields
(rc1) Security: fixes vulnerability disclosed on BUGTRAQ on 2004-06-29
(rc1) Export: Fix export of '0' strings
(rc1) Export: Fix export of queries with empty WHERE clause
(rc1) Copying a table containing a TIMESTAMP under MySQL 4.1.2+
(rc1) Could not create a primary key when there was none before
(rc1) DATETIME field export under MySQL 4.1.3
(rc1) Error copying table data only
(rc1) Navigation: last page button did not show last page number
(rc1) Functions: some functions do not take parameters
(rc1) Wrong table options for non-MyISAM tables
(rc1) Undefined offset when no display field has been defined
(rc2) Encoding tis-620 is not multibyte
(rc2) Export and Excel 2003 behavior
(rc2) Undefined offset in blowfish.php when user upgrades over the same directory
(rc2) Export and empty BLOB
(rc2) "Illegal mix of collations" at various places
(rc2) Was showing the port number after the verbose name
(rc2) Export and TIMESTAMP
(rc2) "Commands out of sync" at various places
(rc2) Could not upload a binary field (under mysqli)
(rc2) Collation problems with the relational tables
(rc2) Export and handling of -- and # comments
(rc2) Problem with the appending of LIMIT clause
(rc2) Data editing: do not empty protected values
(rc2) Calendar popup problem with certain months
(rc2) Problem with foreign key drop-downs
(rc3) Sometimes the calendar popup does not appear
(rc3) Database wrongly named "5"
(rc3) Error clicking on Insert tab
(rc3) Administration: cannot manipulate a user like "user@nothost"
(rc3) Error when ordering by count( * )
(rc3) Browsing foreigners: paging did not work, and data did not return to the field when called from the Search sub-page
(rc3) Cookie auth_type: Now remembers database
(rc3) Theme version checking improved
(rc3) Top left frame not loading (Safari 1.2.3)
(rc3) Consistency of the XHTML labels
(rc3) Focus no longer kept on the databases drop-down
(rc3) Really use the compress option in mysql protocol
(rc3) Tell the client library to use CLIENT_LOCAL_FILES
(rc3) Could not import non-UTF-8 exports
(final) Query window's Import Files submit button
(final) Default value of ThemePath
(final) Export of "0" string
(final) File upload and open_basedir problem
(final) Left frame not reloaded after reading of export file
(pl1) Compatibility fix for PHP 4.1.x and 4.2.x
(pl2) Security: escape special shell characters in MIME-based 'external' transformation
(pl2) Incorrect appending of LIMIT to queries
(pl2) UPDATE statement not showing
(pl3) Security fixes for multiple XSS vulnerabilities
(pl3) Illegal mix of collations for converted strings

Version compatible with PHP 4+ and MySQL 3+.

Sorry, but no files to download are available for this release. Most likely this is too old release and we didn't find it in our archives.

Since July 2015 all phpMyAdmin releases are cryptographically signed by the releasing developer. You should verify that the signature matches the archive you have downloaded. Verification instructions are placed in our documentation in the Verifying phpMyAdmin releases chapter.