Mastering phpMyAdmin 2.8 for Effective MySQL Management
Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 2.8
Published on 10. October 2006
Book
Paperback/Softback
250 pages
978-1-84719-160-1 (ISBN)
Description
Key Features
Effectively administrate your MySQL databases
Manage users and privileges with MySQL Server Administration tools
Get to grips with the hidden features and capabilities of phpMyAdmin
Book DescriptionphpMyAdmin
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.
MySQL
Used by millions of developers, MySQL is the most popular open source database, supporting numerous large dynamic websites and applications. MySQL has acquired this wide popularity by virtue of its open source nature, performance, reliability, robustness, and support for various platforms. However, 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 their 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.
Upgrade Advice
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 donaEUR (TM)t need to upgrade to this new edition of the book.What you will learn
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.
Who this book is forWhether 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
Effectively administrate your MySQL databases
Manage users and privileges with MySQL Server Administration tools
Get to grips with the hidden features and capabilities of phpMyAdmin
Book DescriptionphpMyAdmin
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.
MySQL
Used by millions of developers, MySQL is the most popular open source database, supporting numerous large dynamic websites and applications. MySQL has acquired this wide popularity by virtue of its open source nature, performance, reliability, robustness, and support for various platforms. However, 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 their 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.
Upgrade Advice
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 donaEUR (TM)t need to upgrade to this new edition of the book.What you will learn
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.
Who this book is forWhether 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
More details
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
Illustrations
black & white illustrations
Dimensions
Height: 235 mm
Width: 191 mm
ISBN-13
978-1-84719-160-1 (9781847191601)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin. He started to contribute to the project in December 1998, when he made the multi-language version. He is still involved with phpMyAdmin as a developer and project administrator. Marc is a system administrator at Cegep de Sherbrooke, Qubec, Canada. He has been teaching networking, security, and web application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina. Marc lives in Sherbrooke with his wife and they enjoy spending time with their four children.
Content
Table of Contents