Mastering phpMyAdmin 2.11 for Effective MySQL Management

There is a newer version of this book available - Mastering phpMyAdmin 3.1 for Effective MySQL Management
Mastering phpMyAdmin 2.11 for Effective MySQL Management
eBook: $20.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 25%!
Print + free eBook + free PacktLib access to the book: $55.98    Print cover: $34.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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.

Book Details

Language : English
Paperback : 340 pages [ 235mm x 191mm ]
Release Date : March 2008
ISBN : 1847194184
ISBN 13 : 9781847194183
Author(s) : Marc Delisle
Topics and Technologies : All Books, Web Development, MySQL, Open Source

Table of Contents

Chapter 1: Introducing phpMyAdmin
Chapter 2: Installing phpMyAdmin
Chapter 3: Interface Overview
Chapter 4: First Steps
Chapter 5: Changing Data
Chapter 6: Changing Table Structures
Chapter 7: Exporting Structure and Data
Chapter 8: Importing Structure and Data
Chapter 9: Searching Data
Chapter 10: Table and Database Operations
Chapter 11: The Relational System
Chapter 12: Entering SQL Commands
Chapter 13: The Multi-Table Query Generator
Chapter 14: Bookmarks
Chapter 15: System Documentation
Chapter 16: MIME-Based Transformations
Chapter 17: Character Sets and Collations
Chapter 18: MySQL 5.0 Features
Chapter 19: MySQL Server Administration
Chapter 20: Troubleshooting and Support
  • Chapter 2: Installing phpMyAdmin
    • System Requirements
      • GoPHP5
    • Downloading the Files
    • Installation
      • Installation on a Remote Server Using a Windows Client
      • Installation on a Local Linux Server
      • Installation on Local Windows Servers (Apache, IIS)
    • First Connection Configuration
      • Configuration Principles
      • Web-Based Setup Script
      • Manual Creation of
      • Tips for Editing on a Windows Client
      • The File
      • PmaAbsoluteUri
      • Server-Specific Sections
        • extension
        • PersistentConnections
        • connect_type, socket and port
        • compress Configuration
        • Authentication Type: config
      • Testing the First Connection
    • Multi-Server Configuration
      • Servers Defined in the Configuration File
      • Arbitrary Server
    • Advanced Authentication
      • Authentication Types Offered
      • The Control User
      • Logging Out
      • HTTP Authentication
      • Cookie Authentication
      • Signon
    • Security
      • Directory-Level Protection
      • IP-Based Access Control
        • Rules
        • Order of Interpretation for Rules
        • Simplified Rule for Root Access
      • Restricting the List of Databases
      • Protecting In-Transit Data
    • Upgrading phpMyAdmin
    • Summary
  • Chapter 3: Interface Overview
    • Panels and Windows
      • Login Panels
      • Left and Right Panels
        • Home Page
        • Views
      • Query Window
      • Starting Page
      • Window Titles Configuration
      • General Icon Configuration
      • Natural Sort Order for Database and Table Names
    • Language Selection
    • Themes
      • Theme Configuration
      • Theme Selection
    • Left Panel
      • Logo Configuration
      • Database and Table List
        • Light Mode
        • Full Mode
        • Table Short Statistics
        • Quick-Browsing a Table
        • Nested Display of Tables within a Database
      • Server-List Choice
      • Handling Many Databases or Tables
    • Right Panel
      • Home Page
      • Database View
      • Table View
      • Server View
      • Icons for Home Page and Menu Tabs
    • Query Window
    • Site-Specific Header and Footer
    • MySQL Documentation Links
    • Summary
  • Chapter 4: First Steps
    • Database Creation
      • No Privileges?
      • First Database Creation Is Authorized
    • Creating Our First Table
      • Choosing the Fields
      • Table Creation
      • Choosing Keys
    • Manual Data Insertion
      • Data Entry Panel Tuning for CHAR and VARCHAR
    • Browse Mode
      • SQL Query Links
      • Navigation Bar
      • Query Results Operations
      • Sorting Results
      • Color-Marking Rows
      • Limiting the Length of Each Column
      • Browsing Distinct Values
      • Browse-Mode Customization
    • Creating an Additional Table
    • Summary
  • Chapter 5: Changing Data
    • Edit Mode
      • Moving to Next Field with the Tab Key
      • Moving with Arrows
      • Handling NULL Values
      • Applying a Function to a Value
      • Duplicating Rows of Data
    • Multi-Row Editing
    • Editing the Next Row
    • Deleting Data
      • Deleting a Single Row
      • Deleting Many Rows
      • Deleting All the Rows in a Table
      • Deleting All Rows in Many Tables
    • Deleting Tables
    • Deleting Databases
    • Summary
  • Chapter 6: Changing Table Structures
    • Adding a Field
      • Vertical Mode
      • Horizontal Mode
    • Editing Field Attributes
    • TEXT
    • BLOB (Binary Large Object) Fields
      • Binary Contents Uploads
    • ENUM and SET
      • Calendar Popup
      • TIMESTAMP Options
    • Bit
    • Index Management
      • Single-Field Indexes
      • Multi-Field Indexes and Index Editing
      • FULLTEXT Indexes
      • Table Optimization: Explaining a Query
      • Detection of Index Problems
    • Summary
  • Chapter 7: Exporting Structure and Data
    • Dumps, Backups, and Exports
    • Database Exports
      • The Export Sub-Panel
        • SQL Options
      • The Save as file Sub-Panel
        • File Name Template
        • Compression
        • Choice of Character Set
      • CSV
      • CSV for MS Excel
      • PDF
      • Microsoft Word 2000
      • Native MS Excel (pre-Excel 2000)
      • Open Document Text
      • YAML
    • Table Exports
      • Split-File Exports
    • Selective Exports
      • Exporting Partial Query Results
      • Exporting and Checkboxes
    • Multi-Database Exports
    • Saving the Export File on the Server
      • User-Specific Save Directories
    • Memory Limits
    • Summary
  • Chapter 8: Importing Structure and Data
    • Limits for the Transfer
      • Time Limits
      • Other Limits
      • Partial Imports
      • Temporary Directory
    • Importing SQL Files
    • Importing CSV Files
      • Differences between SQL and CSV Formats
      • Exporting a Test File
      • CSV
      • CSV Using LOAD DATA
        • Requirements
        • Using the LOAD DATA Interface
    • Web Server Upload Directories
    • Summary
  • Chapter 9: Searching Data
    • Single-Table Searches
      • Daily Usage of phpMyAdmin
      • Entering the Search Sub-Page
      • Selection of Display Fields
      • Ordering the Results
      • Search Criteria by Field: Query by Example
      • Print View
      • Wildcard Searching
      • Combining Criteria
      • Applying a WHERE Clause
      • Obtaining Distinct Results
    • Complete Database Search
    • Summary
  • Chapter 10: Table and Database Operations
    • Table Maintenance
    • Changing Table Attributes
      • Table Type
      • Table Comments
      • Table Order
      • Table Options
    • Renaming, Moving, and Copying Tables
      • Appending Data to a Table
    • Multi-Table Operations
      • Repairing an "in use" Table
    • Database Operations
      • Renaming a Database
      • Copying a Database
    • Summary
  • Chapter 11: The Relational System
    • Relational MySQL?
      • InnoDB
    • Linked-Tables Infrastructure
      • Goal of the Infrastructure
      • Location of the Infrastructure
      • Installing Linked-Tables Infrastructure
        • Multi-User Installation
        • Single-User Installation
    • Defining Relations with the Relation View
      • Internal Relations
        • Defining the Relation
        • Defining the Display Field
      • InnoDB Relations
        • InnoDB Tables without Linked-Tables Infrastructure
    • Defining Relations with the Designer
      • Interface Overview
      • Defining Relations
        • InnoDB Relations
      • Defining the Display Field
      • Exporting for PDF Schema
    • Benefits of the Defined Relations
      • Foreign Key Information
      • The Drop-Down List of Foreign Keys
      • The Browseable Foreign-Table Window
      • Referential Integrity Checks
      • Automatic Updates of Metadata
    • Column-Commenting
      • Automatic Migration
    • Summary
  • Chapter 12: Entering SQL Commands
    • The SQL Query Box
      • The Database View
      • The Table View
        • The Fields Selector
        • Clicking Into the Query Box
    • The Query Window
      • Query Window Options
      • Session-Based SQL History
      • Database-Based SQL History (Permanent)
      • Editing Queries in the Query Window
    • Multi-Statement Queries
    • Pretty Printing (Syntax-Highlighting)
    • The SQL Validator
      • System Requirements
      • Making the Validator Available
      • Validator Results
        • Standard-Conforming Queries
        • Non Standard-Conforming Queries
    • Summary
  • Chapter 13: The Multi-Table Query Generator
    • Choosing Tables
    • Column Criteria
      • Field Selector: Single-Column or All Columns
      • Sorts
      • Showing a Column
      • Updating the Query
      • Criteria
        • Adjusting the Number of Criteria Rows
        • Adjusting the Number of Criteria Columns
    • Automatic Joins
    • Executing the Query
    • Summary
  • Chapter 14: Bookmarks
    • Creating a Bookmark after a Successful Query
    • Storing a Bookmark before Sending a Query
    • Multi-Query Bookmarks
    • Recalling from the Bookmarks List
      • Bookmark Execution
      • Bookmark Manipulation
    • Public Bookmarks
    • The Default Initial Query for a Table
    • Bookmark Parameters
      • Creating a Parameterized Bookmark
      • Passing a Parameter Value to a Bookmark
    • Executing Bookmarks by Browsing the pma_bookmark Table
    • Summary
  • Chapter 15: System Documentation
    • The Database Print View
    • The Selective Database Print View
    • The Table Print View
    • The Data Dictionary
    • Relational Schema in PDF
      • Adding a Third Table to Our Model
      • Editing PDF Pages
        • Page Planning
        • Creating a New Page
        • Editing a Page
        • Displaying a Page
        • A Note about Fonts Used
      • Using the Designer for PDF Layout
    • Summary
  • Chapter 16: MIME-Based Transformations
    • The MIME Column's Settings
      • MIME Types
      • Browser Transformations
      • Transformation Options
    • Requirements for Image Generation
      • The GD2 Library
      • The JPEG and PNG Libraries
      • Memory Limits
    • Examples of Transformations
      • Clickable Thumbnail (.jpeg or .png)
      • Links to an Image
      • Date Formatting
      • Links from Text
        • text/plain: link
        • text/plain: imagelink
      • Preserving the Original Formatting
      • Displaying Parts of a Text
      • Download Link
      • Hexadecimal Representation
      • SQL Pretty Printing
      • External Applications
        • External Application Example: In-Cell Sort
    • Summary
  • Chapter 17: Character Sets and Collations
    • Language Files and UTF-8
    • Versions of MySQL Prior to 4.1.x
      • Data Recoding
      • Character Sets
      • Choosing the Effective Character Set
      • The Impact of Switching
      • Importing and Exporting with Character Sets
    • MySQL 4.1.x and Later
      • Collations
      • The Home Page
        • Creating a Database
        • Available Character Sets and Collations
        • Effective Character Sets and Collations
      • The Database View
      • The Table View
      • Importing and Exporting with Character Sets
      • Server View
    • Kanji Support
    • Summary
  • Chapter 18: MySQL 5.0 Features
    • Observations on the History of MySQL 5.0
    • Views
      • Manually Creating a View
      • Right Panel and Views
      • Creating a View from Results
      • Renaming a View
      • Performance Hint
    • Routines: Stored Procedures and Functions
      • Creating a Stored Procedure
        • Changing the Delimiter
        • Entering the Procedure
      • Testing the Procedure
      • Manipulation
      • Manually Creating a Function
      • Testing the Function
      • Exporting Stored Procedures and Functions
    • Triggers
      • Manually Creating a Trigger
      • Testing the Trigger
    • Information_schema
    • Profiling
    • Summary
  • Chapter 19: MySQL Server Administration
    • Entering the Server View
      • User and Privileges Management
      • The User Overview
      • Adding a User
        • User Name
        • Host
        • Password
        • Database Creation and Rights
        • Global Privileges
        • Resource Limits
      • Editing a User
        • Edit Privileges
        • Database-Specific Privileges
        • Changing the Password
        • Changing Login Information or Copying a User
      • Removing a User
    • Database Information
      • Enabling Statistics
      • Sorting Statistics
      • Checking the Database Privileges
      • Dropping Selected Databases
    • Server Operations
      • Server Status Verification
        • The General Status Page
        • InnoDB Status
      • Server Variables
      • Server Processes
      • Storage Engines
      • The Binary Log
    • Summary
  • Chapter 20: Troubleshooting and Support
    • System Requirements
    • Base Configuration
    • Solving Common Errors
      • Error Messages
        • Cannot Load MySQL Extension
        • MySQL Said: Can't Connect to Local MySQL Server
        • Socket Problem (Linux/UNIX)
        • Named Pipe Problem (Windows)
        • Error # 2003: The Server is not Responding
        • MySQL Said: Access Denied
        • When Using http Authentication
        • When Using http, cookie, or config Authentication
        • Access Denied ... "using password: NO"
        • Access Denied ... "using password: YES"
        • Warning: Cannot Add Header Information
        • MySQL Said: Error 127, Table Must Be Repaired
        • BLOB Column Used in Key Specification without a Key Length
        • IIS: No Input File Specified
        • A "404: page not found" Error when Modifying a Row
      • Other Problems
        • Blank Page or Weird Characters
        • Not Being Able to Create a Database
        • Problems Importing Large Files or Uploading Large BLOB Files
        • MySQL Root Password Lost
        • Duplicate Field Names when Creating a Table
        • Authentication Window Displayed More Than Once
        • Column Size Changed by phpMyAdmin
        • Seeing Many Databases that Are Not Ours
        • Not Being Able to Store a Value Greater Than 127
    • Seeking Support
      • FAQs
      • Help Forums
        • Creating a SourceForge Account
        • Choosing the Thread Title
        • Reading the Answers
      • Support Tracker
      • Bug Tracker
        • Environment Description
        • Bug Description
    • Contributing to the Project
      • The Code Base
      • Translation Updates
      • Patches
    • Future phpMyAdmin Versions
    • Summary

Marc Delisle

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, Québec, 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.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Mastering phpMyAdmin 2.11 for Effective MySQL Management +    MooTools 1.2 Beginner's Guide =
50% Off
the second eBook
Price for both: £19.75

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • 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.

In Detail

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.

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.


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.

Who this book is for

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.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software