Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering phpMyAdmin 2.11 for Effective MySQL Management Marc Delisle   Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 2.11   Effectively administer your MySQL databases with phpMyAdmin. Manage users and privileges with MySQL Server Administration tools. Get to grips with the hidden features and capabilities of phpMyAdmin. In More Detail   Available Now Cover price   $34.99 Standard   $31.49 save 10% Multi-buy Discount   $28.69 save 18% order two or more items Change Currency   UK £ US $ EU € what is this? Free shipping! US, UK, Europe, Aus, NZ & selected Asian countries Where else can I buy this book? Also available from: select a store Lehmans (DE)Dataclub OY (FI)Temporeal (BR)Combooks (Israel)Amazon (US)Quantum Books (US MA)Amazon.de (DE)Amazon.co.uk (UK)Bookware.com (AU)Polyteknisk (DK)Amazon.fr (FR)

You can change your mind later Returns Information

eBook Version eBooks are non returnable and non refundable. Packt eBook Licence agreement Adobe PDF eBook Mastering phpMyAdmin 2.11 for Effective MySQL Management [eBook] File size: 5.33 MB Packt eBooks are a low cost and immediate companion or alternative to print books. Packt eBooks can be printed. Copying is disabled. They are password protected with your email address. Packt eBook User Guide Buy two or more eBooks and get 35% off eBook only $27.99 $23.79 Save 15% off eBook Book and eBook bundle $58.78 $35.69   Save 10% off Book & 85% off eBook

Language English
Paperback 340 pages [191mm x 235mm]
Release date March 2008
ISBN 1847194184
ISBN 13 978-1-847194-18-3
Author(s) Marc Delisle
Topics and Technologies PHP/MySQL

This book is an upgrade from the previous version that covered phpMyAdmin Version 2.8. Version 2.10 introduced a new GUI for relations, called Designer, and version 2.11 adds support for creating Views from query results, manages triggers, procedures and functions and has an improved interface for servers handling large number of databases/tables.

Book Reviews Ken Guest: "I scarcely believe this book could be much more detailed, especially as it often has more than two screen shots per page - it is no wonder that I now know much more of what phpMyAdmin is capable of!" Verens.com: ...the book detailed everything I can think of (and more) about phpMyAdmin - I learned about some features in phpMyAdmin that I was not already aware of. assist.dyndns.biz: The book does definitely what has been promised. It leaves no secrets to uncover and when you have read it you probably won't need to read it again. Not only because the book is clear but again because of the logic behind PhpMyAdmin. So if you are a first time user of PhpMyAdmin this book is definitely worth every penny.

PhpMyAdmin is a well known and popular open-source tool written in PHP intended to handle the administration of MySQL over the Internet. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, and manage keys on fields. While most MySQL developers use routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool.

MySQL is the most popular open-source database, used by millions of developers and supporting numerous large dynamic websites and applications. MySQL acquired this wide popularity by virtue of its open-source nature, performance, reliability, robustness, and support for various platforms. This popularity has also been helped by the existence of phpMyAdmin, the industry-standard administration tool that makes database management easy for both the experienced developer and the novice.

The powerful graphical interface that it provides to MySQL has made phpMyAdmin an indispensable tool for MySQL and web developers. Every phpMyAdmin user can benefit from unlocking the full potential of this powerful application. Whether you are an experienced developer, system administrator, web designer, or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your databases.

• Common reasons for installing PhpMyAdmin
• Managing multiple servers on single copy of PhpMyAdmin
• Securing your PhpMyAdmin installation
• Upgrading your PhpMyAdmin installation
• Managing databases, data table structures, and indexes to create efficient databases
• Administering MySQL users and privileges
• Getting server and database statistics
• Generating better documentation of evolving table structures

Along the way you will build a more detailed understanding of SQL and how it works in MySQL.

This book is a tutorial 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.

Whether you are an experienced developer, system administrator, web designer or new to MySQL, phpMyAdmin is a must-have tool for anyone who needs to manage MySQL databases and tables. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.

Marc Delisle
Marc Delisle is a member of the MySQL Developers Guild – which regroups community developers – because of his involvement with phpMyAdmin. He started to contribute to this popular MySQL web interface in December 1998, when he made the first multi-language version. He has been actively involved with the phpMyAdmin project since May 2001 as a developer and project administrator.

He has worked since 1980 at Collège de Sherbrooke, Québec, Canada, as an application programmer and network manager. He has also been teaching networking, security, Linux servers, and PHP/MySQL application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina.