PHPMyAdmin 3.1
PHPMyAdmin 3.1 Review
phpMyAdmin is a ten year old project with a stable and flexible code base. Among the awards won by this tool, the more prestigious ones include: “Best PHP Application” as well as “Best Tool or Utility for Data Base Admins”.
All the necessary documentation for the tool is provided in a book like format by one of the developers, which is also available in the languages: English, German, Spanish and Czech to name a few. The utility is written in PHP scripting language and aims at effectively handling the administration of MySQL databases over the internet.
PHPMyAdmin supports a wide range of operations that can be carried out on MySQL server databases from the websites. While most of the operations are user interfaced, for example; managing databases, tables, records, fields, keys, indexes, user permissions etc., support is also provided for the direct execution of SQL statements. Though the product is widely used and critically acclaimed for its features, most of the facilities that accompany the tool are still in the development stage.
24×7 support is provided by the PHPMydmin team which helps the user with installation and operational issues. Support channels are also provided for the user to get help from other users connected to the same database server.
Some of the features of PHPMyAdmin 3.1.2 –rc1 include:
. Support provided for multiple database environments with searches conducted on all databases or on their subsets.
. Support for the following features of MySQL: ability to browse and drop databases, tables, views, fields and indexes, ability to create, copy, drop, rename and alter databases, tables, fields and indexes, ability to maintain the server, databases and tables, with proposals on server configuration, ability to execute, edit and bookmark any SQL-statement, and batch-queries, ability to manage MySQL users and privileges and the ability to manage stored procedures and triggers.
. Support provided for the import and export of data from and to different formats including CSV, SQL, XML and PDF etc.
. User friendly interface with the ability to create graphic images of the data base layout.
. Support for the creation of both simple and complex queries with the ability to transform the stored data from one format to another. This is achieved with the help of predefined functions.

