Download phpMyAdmin 2.6.0 beta 1

The folks behind phpMyAdmin have released the first beta version of the 2.6 branch after two alpha releases. This mountain of PHP scripts allows you to maintain a MySQL database remotely or not. As of this beta, no new features will be added, but the team will only focus on fixing bugs. New since the previous versions include a new layout and the ability to use skins. As usual, a new release is available to download in three different flavors: bzip2† tarball and zip† The changelog announces the following changes:

• 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
• Security: Protection against cookie hijacking: encrypt also the user name, and set a time limit on the validity of encrypted password in the cookie
• “(Un)check all” link for privileges page
• (alpha2)Optional display of server choice as left
• (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

Fixes:

• 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
• Edit:
  • Invalid escaping or + 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 bookmark 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)