Table of Contents
Preface
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
Index
- Chapter 1: Introducing phpMyAdmin
- PHP and MySQL: The Leading Open-Source Duo
- What is phpMyAdmin?
- History
- Awards
- phpMyAdmin Features Summary
- Summary
- 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 config.inc.php
- Tips for Editing config.inc.php on a Windows Client
- The config.inc.php 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
- System Requirements
- 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
- Panels and Windows
- 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
- Database Creation
- 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
- Edit Mode
- 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
- DATE, DATETIME, and TIMESTAMP
- 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
- Adding a Field
- 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
- Microsoft Word 2000
- Native MS Excel (pre-Excel 2000)
- Open Document Text
- YAML
- The Export Sub-Panel
- 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
- Limits for the Transfer
- 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
- Single-Table Searches
- 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
- Internal Relations
- 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
- Relational MySQL?
- 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
- The SQL Query Box
- 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
- The MIME Column's Settings
- 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
- Creating a Stored Procedure
- 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
- Server Status Verification
- Summary
- Entering the Server View
- 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
- Error Messages
- 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
