Packt Publishing 2006 | ISBN-10: 1847191606 | 316 Pages | PDF | 4,3 MB

This book is an upgrade to phpMyAdmin Version 2.8. Written by a member of the development team, this book serves as a comprehensive guide to helping you unlock the full potential of phpMyAdmin 2.8 phpMyAdmin.

Providing a powerful graphical interface for managing MySQL, phpMyAdmin is one of the most popular open source applications. 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.

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.

You will learn how to:
Administer MySQL users and privileges, and get statistics about MySQL servers and databases
Manage databases, table data and structures, and indexes - Use bookmarks and metadata
Generate multiple SQL queries
Generate better documentation of evolving table structures

Along the way you will build a more detailed understanding of SQL and how it works in MySQL. As an application developer you’ll learn how to use phpMyAdmin to:
Effectively perform day-to-day database and table management.
Create efficient database tables and relational structures
Document your evolving data structure easily

As a MySQL server administrator, you will benefit from the in-depth and practical coverage of
Using phpMyAdmin to manage users and privileges
Getting server and database statistics

All database users will be able to expand and refine their knowledge of SQL in a MySQL context by using phpMyAdmin to track SQL execution and results. The prior edition of this book was written for version 2.6. Most of the changes to phpMyAdmin in version 2.8 are in the user interface and not the underlying functionality. This book brings the screen shots and user instructions into line with the new interface. If as a reader you are happy with the new interface already you don’t need to upgrade to this new edition of the book. The 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. 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.