Book description
A complete guide to getting started with phpMyAdmin 3.4 and mastering its features.
- A step-by-step tutorial for manipulating data with the latest version of phpmyadmin
- Administer your MySQL databases with phpMyAdmin
- Manage users and privileges with MySQL Server Administration tools
- Learn to do things with your MySQL database and phpMyAdmin that you didn't know were possible!
In Detail
phpmyAdmin is one of the most widely used open source applications, which is written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 52 languages.
phpMyAdmin is a web-based front-end to manage MySQL databases and has been adopted by a number of Open-Source distributors.
Mastering phpMyAdmin 3.4 for Effective MySQL Management is an easy-to-read, step-by-step practical guide that walks you through every facet of this legendary tool—phpMyAdmin—and takes you a step ahead in taking full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.
This is the official guide to this popular MySQL web interface. It starts with installing and configuring phpMyAdmin, including the phpMyAdmin Configuration Storage, which is the key to its advanced features. This is followed by configuring authentication in phpMyAdmin and setting parameters that influence the interface as a whole.
You will also learn some advanced features such as defining inter-table relations with the advanced Designer module. You will practice synchronizing databases on different servers and managing MySQL replication to improve performance and data security. Moreover, you will also store queries as bookmarks for their quick retrieval.
In addition to it, this book helps you to learn new features introduced in version 3.4.x such as users’ preferences, producing charts and the visual multi-table query builder.
Table of contents
-
Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Table of Contents
- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Getting Started with phpMyAdmin
- PHP and MySQL: The leading open source duo
- What is phpMyAdmin?
- Installing phpMyAdmin
- Configuring phpMyAdmin
- Installing phpMyAdmin configuration storage
- Upgrading phpMyAdmin
- Summary
- 2. Configuring Authentication and Security
- 3. Over Viewing the Interface
- 4. Creating and Browsing Tables
-
5. Changing Data and Structure
- Changing data
- Changing table structure
- Summary
- 6. Exporting Structure and Data (Backup)
- 7. Importing Structure and Data
- 8. Searching Data
- 9. Performing Table and Database Operations
- 10. Benefiting from the Relational System
- 11. Entering SQL Statements
- 12. Generating Multi-table Queries
-
13. Synchronizing Data and Supporting Replication
- Synchronizing data and structure
- Supporting MySQL replication
- Summary
- 14. Using Query Bookmarks
- 15. Documenting the System
-
16. Transforming Data using MIME
- Browsing data without transformations
- Enabling transformations
- Examples of transformations
- Summary
- 17. Supporting Features Added in MySQL 5
- 18. Tracking Changes
- 19. Administrating the MySQL Server
- A. Troubleshooting and Support
- Index
Product information
- Title: Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Author(s):
- Release date: February 2012
- Publisher(s): Packt Publishing
- ISBN: 9781849517782
You might also like
book
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fifth Edition
Learn PHP and MySQL programming— the quick and easy way! Easy visual approach uses demonstrations and …
book
Website Hosting and Migration with Amazon Web Services: A Practical Guide to Moving Your Website to AWS
Understand the steps necessary to host your website using the Amazon Web Services (AWS) platform. You …
book
Transforming Your Business with AWS
Expert guidance on how to use Amazon Web Services to supercharge your digital services business In …
book
Plan Your Prosperity: The Only Retirement Guide You'll Ever Need, Starting Now--Whether You're 22, 52 or 82
Whether you're in retirement, just getting ready to retire, or 5, 10, or 40 years out, …