Mastering phpMyAdmin for Effective MySQL Management

Discover the real power of phpMyAdmin. Increase your MySQL productivity and control. . Learn to unlock the full potential of phpMyAdmin . Increase your productivity and control when working with your databases . Benefit from in-depth, practical coverage of using phpMyAdmin to manage users and privileges and getting server and database statistics . Get to grips with the hidden features and capabilities of phpMyAdmin This book is a comprehensive guide helping you to unlock the full potential of phpMyAdmin. 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 MySQL. 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'll build a more detailed understanding of SQL and how it works in MySQL. In the book you'll learn about: . Installing, configuring, and customizing phpMyAdmin. . MySQL administration. . Managing databases, table data and structures. . Managing indexes. . Exporting databases and table data and structures. . Searching databases and tables . Using metadata and bookmarks . Generating multiple SQL queries . Documenting table structures . Mime-based transformation