- News - lists.phpmyadmin.net

[Phpmyadmin-news] phpMyAdmin 2.6.1-rc1 is released
by Marc Delisle 12 Dec '04

12 Dec '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.1-rc1 http://www.phpmyadmin.net phpMyAdmin 2.6.1-rc1 - December 12th, 2004 ========================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of the first release candidate of phpMyAdmin 2.6.1. Almost three months have passed since 2.6.0, although three patch releases were made to take care of several security alerts we received. In 2.6.1 there are two more security fixes (and the official alert will be published in a few days). As a consequence of one of these fixes, if you want to use MIME-based external transformations you have to use a PHP version of 4.3.0 or later. A big speed improvement for users of the "cookie" authentication type is included in 2.6.1-rc1, but you must be running on a Web server with the mcrypt PHP module. Another improvement worth mentionning, which relates to a new feature offered on MySQL 4.1.2+: on multi-user installations, the control user no longer needs to have any rights to the "mysql" db. It is now only used to access the linked-tables infrastructure (pmadb). Please note that it is not recommended to run this testing release on production environments. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- 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 * 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..." 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 Detailed list of changes since version 2.2.0 is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). To be informed about new releases fixing these problems, please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- phpMyAdmin is intended to handle the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: - create, copy and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 47 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Marcel Tschopp <ne0x_at_users.sourceforge.net> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Marc Delisle/ 2004-12-12

1 0

[Phpmyadmin-news] phpMyAdmin 2.6.0-pl3 and security alert
by Marc Delisle 18 Nov '04

18 Nov '04

Hi, Patch level 3 of phpMyAdmin 2.6.0 has been released, fixing some XSS vulnerabilities. Our PMASA-2004-3 security announcement gives more details and further references. The announcement and downloads details are available at http://www.phpmyadmin.net Marc Delisle, for the team

1 0

[Phpmyadmin-news] phpMyAdmin 2.6.0 is released
by phpMyAdmin devel team 27 Sep '04

27 Sep '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.0 http://www.phpmyadmin.net phpMyAdmin 2.6.0 - September 27th, 2004 ======================================= A set of PHP-scripts to manage MySQL over the Web. -------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of phpMyAdmin 2.6.0. Supporting the new improved MySQL extension of PHP5 (MySQLi), phpMyAdmin has made a giant step towards the new PHP version and the upcoming MySQL versions. phpMyAdmin has acquired a new CSS-based theme system. Two themes are included, and can be chosen from the main menu. Documentation is included (see FAQ 2.7) to create your own themes. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- 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 o better performance o improved security * Improved support for character sets * Support for UTF-8 databases under MySQL 4.1 * Site-configurable header and footer * Export: o can add custom text to SQL export headers o support for IF NOT EXISTS o support for INSERT IGNORE and UPDATE IGNORE o use unbuffered queries o enclosing SQL export in a transaction o selective row export o 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 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 value * (rc2)Support for SHOW STORAGE ENGINES and SHOW TABLE TYPES * (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: * 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: o on-the-fly compression problem o CSV problem with double-byte characters o UPDATE option does not work * Editing: o Invalid escaping of + in ENUM o Undefined submit_mult o Cannot edit first row when no primary key o Cannot edit big table structure o Multi-edit: changes are lost o Editing of double and float numbers o 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) * (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 Detailed list of changes since version 2.2.0 is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ There are localized versions of the documentation for some languages, available on the site. The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). - An "Illegal mix of collations" error happens on the Search page under certain circumstances, on MySQL versions 4.1.x and later (bug #1033388) To be informed about new releases fixing these problems, please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- phpMyAdmin is intended to handle the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: - create and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 47 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Marcel Tschopp <ne0x_at_users.sourceforge.net> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA EOF -- Alexander M. Turek and Marc Delisle/ 2004-09-27

1 0

[Phpmyadmin-news] phpMyAdmin 2.6.0-rc2 is released
by Marc Delisle 07 Sep '04

07 Sep '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.0-rc2 http://www.phpmyadmin.net phpMyAdmin 2.6.0-rc2 - September 6th, 2004 ========================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of the second release candidate of phpMyAdmin 2.6.0. Supporting the new improved MySQL extension of php5 (MySQLi), phpMyAdmin has made a giant step towards the upcoming PHP and MySQL versions. During beta-1, phpMyAdmin has acquired a new CSS-based theme system. Two themes are included, and can be chosen from the main menu. Documentation is included (see FAQ 2.7) to create your own themes. As the new milestone should to be as stable as possible, any feedback about 2.6.0-rc2 would be appreciated. Please note, that it is not recommended to run this testing release on production environments. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- 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 o better performance o improved security * Improved support for character sets * Support for UTF-8 databases under MySQL 4.1 * Site-configurable header and footer * Export: o can add custom text to SQL export headers o support for IF NOT EXISTS o support for INSERT IGNORE and UPDATE IGNORE o use unbuffered queries o enclosing SQL export in a transaction o selective row export o 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 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 value * (rc2)Support for SHOW STORAGE ENGINES and SHOW TABLE TYPES * (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: * 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: o on-the-fly compression problem o CSV problem with double-byte characters o UPDATE option does not work * Editing: o Invalid escaping of + in ENUM o Undefined submit_mult o Cannot edit first row when no primary key o Cannot edit big table structure o Multi-edit: changes are lost o Editing of double and float numbers o 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) * (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 Detailed list of changes since version 2.2.0 is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). To be informed about new releases fixing these problems, please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- phpMyAdmin is intended to handle the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: - create and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 47 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Marcel Tschopp <ne0x_at_users.sourceforge.net> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA EOF -- Alexander M. Turek and Marc Delisle/ 2004-09-06

1 0

[Phpmyadmin-news] phpMyAdmin 2.5.7-pl1 is released
by Marc Delisle 30 Jun '04

30 Jun '04

The Internet, 2004-06-30 Greetings, The phpMyAdmin development team announces the availability of phpMyAdmin 2.5.7, patch level 1. This version fixes the vulnerability dated 2004-06-29, released on BUGTRAQ (see our Documentation.html, FAQ 8.2). We would like to put emphasis on the disappointment we feel when a bugreporter does not contact the authors of a software first, before posting any exploits. The common way to report this, is to give the developers a reasonable amount of time to respond to an exploit before it is made public. Download/support information on http://www.phpmyadmin.net. Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.6.0-beta2 released
by Marc Delisle 29 Jun '04

29 Jun '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.0-beta2 http://www.phpmyadmin.net phpMyAdmin 2.6.0-beta2 - June 28th, 2004 ======================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of the second beta release of phpMyAdmin 2.6.0. Because of significant changes inside the database connection methods and major improvements to the MySQL 4.1 compatibility, the team decided to release this beta version from phpMyAdmin's current development code. Supporting the new improved MySQL extension of php5 (MySQLi), phpMyAdmin has made a giant step towards the upcoming PHP and MySQL versions. For beta-1, phpMyAdmin has acquired a new CSS-based theme system. Two themes are included, and can be chosen from the main menu. Full documentation about the theme system will be done before the final 2.6.0 version. As the new milestone should to be as stable as possible, any feedback about 2.6.0-beta1 would be appreciated. Please note, that it is not recommended to run this testing release on production environments. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- Improvements: * PHP 5 mysqli extension support o better performance o improved security * Improved support for character sets * Support for UTF-8 databases under MySQL 4.1 * Site-configurable header and footer * Export: o can add custom text to SQL export headers o support for IF NOT EXISTS o support for INSERT IGNORE and UPDATE IGNORE o use unbuffered queries o enclosing SQL export in a transaction o selective row export o 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 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 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: o on-the-fly compression problem o CSV problem with double-byte characters o UPDATE option does not work * Editing: o Invalid escaping of + in ENUM o Undefined submit_mult o Cannot edit first row when no primary key o Cannot edit big table structure o Multi-edit: changes are lost o Editing of double and float numbers o 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) * (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 Detailed list of changes since version 2.2.0 is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). To be informed about new releases fixing these problems, please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- phpMyAdmin is intended to handle the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: - create and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 42 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Marcel Tschopp <ne0x_at_users.sourceforge.net> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA EOF -- Alexander M. Turek and Marc Delisle/ 2004-06-28

1 0

[Phpmyadmin-news] phpMyAdmin-2.6.0-beta1 is released
by Olivier Mueller 24 Jun '04

24 Jun '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.0-beta1 http://www.phpmyadmin.net phpMyAdmin 2.6.0-beta1 - June 24th, 2004 ======================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of the first beta release of phpMyAdmin 2.6.0. Because of significant changes inside the database connection methods and major improvements to the MySQL 4.1 compatibility, the team decided to release this beta version from phpMyAdmin's current development code. Supporting the new improved MySQL extension of php5 (MySQLi), phpMyAdmin has made a giant step towards the upcoming PHP and MySQL versions. For beta-1, phpMyAdmin has acquired a new CSS-based theme system. Two themes are included, and can be chosen from the main menu. Full documentation about the theme system will be done before the final 2.6.0 version. As the new milestone should to be as stable as possible, any feedback about 2.6.0-beta1 would be appreciated. Please note, that it is not recommended to run this testing release on production environments. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- Improvements: * PHP 5 mysqli extension support o better performance o improved security * Improved support for character sets * Support for UTF-8 databases under MySQL 4.1 * Site-configurable header and footer * Export: o can add custom text to SQL export headers o support for IF NOT EXISTS o support for INSERT IGNORE and UPDATE IGNORE o use unbuffered queries o enclosing SQL export in a transaction o selective row export o 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 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 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: o on-the-fly compression problem o CSV problem with double-byte characters o UPDATE option does not work * Editing: o Invalid escaping of + in ENUM o Undefined submit_mult o Cannot edit first row when no primary key o Cannot edit big table structure o Multi-edit: changes are lost o Editing of double and float numbers o 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) Detailed list of changes since version 2.2.0 is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). To be informed about new releases fixing these problems, please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- phpMyAdmin is intended to handle the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: - create and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 42 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Marcel Tschopp <ne0x_at_users.sourceforge.net> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA EOF -- Alexander M. Turek and Marc Delisle/ 2004-06-24

1 0

[Phpmyadmin-news] phpMyAdmin 2.5.7 is released
by Marc Delisle 09 Jun '04

09 Jun '04

The Internet, 2004-06-09 Greetings, The phpMyAdmin development team is pleased to announce the availability of phpMyAdmin 2.5.7. This version adds support for MySQL 4.1.2. Meanwhile, development continues for the upcoming 2.6.0 MySQL 4.1 / 5.0 Note: phpMyAdmin's support for MySQL 4.1 / 5.0 is still experimental Fixes: * invalid escaping of + in ENUM * handling of GRANT...TO * handling of floating point digits * better error detection when export fails * password error when copying a user * copying a user with table privileges * export: handling of multi-column foreign keys * new collation page latin1_spanish_ci * support for MySQL 4.1.2 (table type is called "engine") Download/support information on http://www.phpmyadmin.net. Marc Delisle, for the team.

1 0

[Phpmyadmin-news] phpMyAdmin 2.6.0-alpha2 is released!
by Marc Delisle 07 May '04

07 May '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.0-alpha2 http://www.phpmyadmin.net phpMyAdmin 2.6.0-alpha2 - May 7th, 2004 ======================================= A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of the second alpha release of phpMyAdmin 2.6.0. Because of significant changes inside the database connection methods and major improvements to the MySQL 4.1 compatibility, the team decided to release this alpha version from phpMyAdmin's current development code. Supporting the new improved MySQL extension of php5 (MySQLi), phpMyAdmin has made a giant step towards the upcoming PHP and MySQL versions. As the new milestone should to be as stable as possible, any feedback about 2.6.0-alpha2 would be appreciated. Please note, that it is not recommended to run this testing release on production environments. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- Improvements: * PHP 5 mysqli extension support o better performance o improved security * Improved support for character sets * Support for UTF-8 databases under MySQL 4.1 * Site-configurable header and footer * Export: o can add custom text to SQL export headers o support for IF NOT EXISTS o support for INSERT IGNORE and UPDATE IGNORE o use unbuffered queries o enclosing SQL export in a transaction o selective row export o 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 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 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: o on-the-fly compression problem o CSV problem with double-byte characters o UPDATE option does not work o (alpha2)Handling of multi-column foreign keys * Editing: o Invalid escaping of + in ENUM o Undefined submit_mult o Cannot edit first row when no primary key o Cannot edit big table structure o Multi-edit: changes are lost o Editing of double and float numbers o 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 Detailed list of changes since version 2.2.0 is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- To be informed about new releases fixing the problems, please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- phpMyAdmin is intended to handle the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: - create and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 42 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Marcel Tschopp <ne0x_at_users.sourceforge.net> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2, as published by the Free Software Foundation. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA EOF -- Alexander M. Turek and Marc Delisle/ 2004-05-07

1 0

[Phpmyadmin-news] "Mastering phpMyAdmin for Effective MySQL Management"
by Marc Delisle 04 May '04

04 May '04

Finally a phpMyAdmin book! Dear phpMyAdmin users, It is my pleasure to announce the immediate availability of "Mastering phpMyAdmin for Effective MySQL Management". I have written this book with all phpMyAdmin users in mind -- newbies and power users, and I think it's great that the community can now have a tutorial and reference manual to rely upon. Mastering phpMyAdmin for Effective MySQL Management will help you to unlock the full potential of phpMyAdmin and will show you how to increase your productivity and control when working with your MySQL. This book begins with a comprehensive tutorial of phpMyAdmin that systematically explains and demonstrates the potential of this tool. It then goes on to show the less well known and generally under-used features and capabilities of phpMyAdmin in depth. For more information, please visit: http://www.packtpub.com/view_book/isbn/1904811035 Marc Delisle phpMyAdmin.net

1 0