Mastering phpMyAdmin 3.4 for Effective MySQL Management

Marc Delisle

• Publisher: Packt Publishing
• Year: 2012
• ISBN:
  9781849517782
• Edition: 1
• Topic: Ciencia de la computación
• Subtopic: Bases de datos

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.

Approach

This is a step-by-step instructional guide to get you started easily with phpMyAdmin and teach you to manage and perform database functions on your database. You will first be introduced to the interface and then build basic tables and perform both simple and advanced functions on the created database. The book progresses gradually and you will follow it best by reading it sequentially.

Who this book is for

If you are a developer, system administrator, or web designer who wants to manage MySQL databases and tables efficiently, then this book is for you. This book assumes that you are already wellacquainted with MySQL basics. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.

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

Support files, eBooks, discount offers, and more

Why Subscribe?

Free Access for Packt account holders

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Getting Started with phpMyAdmin

PHP and MySQL: The leading open source duo

What is phpMyAdmin?

Project documentation

Installing phpMyAdmin

Required information

System requirements

Downloading the files

Installing on different platforms

Installing on a remote server using a Windows client

Installing on a local Linux server

Installing on a local Windows server (Apache, IIS)

Configuring phpMyAdmin

The config.inc.php file

Avoiding false error messages about permissions on config.inc.php

Configuration principles

Web-based setup script

Manually creating config.inc.php

Tips for editing config.inc.php on a Windows client

Description of some configuration parameters

PmaAbsoluteUri

Server-specific sections

extension

connect_type, socket, and port

compress

PersistentConnections

controluser

Installing phpMyAdmin configuration storage

Goal of the configuration storage

Location of the configuration storage

Performing the installation

Installing for a single user

Installing for multiple users

Upgrading phpMyAdmin

Summary

2. Configuring Authentication and Security

Logging in to MySQL through phpMyAdmin

Logging in to an account without a password

Authenticating a single user with config

Testing the MySQL connection

Authenticating multiple users

Authenticating with HTTP

Authenticating with cookie values

Authenticating with signon mode

Configuring for multiple server support

Defining servers in the configuration file

Authenticating through an arbitrary server

Logging out

Securing phpMyAdmin

Protecting phpMyAdmin at directory level

Displaying error messages

Protecting with IP-based access control

Defining rules

Order of interpretation for rules

Blocking root access

Protecting in-transit data

Summary

3. Over Viewing the Interface

Over viewing panels and windows

Login panels

Navigation and main panels

Home page

Views

Query window

Starting page

Customizing general settings

Configuring window title

Natural sort order for database and table names

Creating site-specific header and footer

Themes

Configuring themes

Selecting themes

Selecting a language

Slider

Restricting the list of databases

Deactivating Ajax

Character sets and collations

Effective character sets and collations

Navigation panel

Configuring the logo

Database and table list

Light mode

Tree display of database names

Table name filter

Full mode

Table abridged statistics

Table quick-access icon

Nested display of tables within a database

Counting the number of tables

Choosing from the server list

Handling many databases or tables

Limits on the interface

Improving fetch speed

Main panel

Home page

Database view

Table view

Server view

Icons for home page and menu tabs

Opening a new phpMyAdmin window

User preferences

Accessing user preferences

Possible locations for saving preferences

Saving in phpMyAdmin configuration storage

Saving in a file

Saving in the browser's local storage

Changing settings

Disallowing specific preferences

Showing developer settings

Query window

Summary

4. Creating and Browsing Tables

Creating a database

No privileges

First database creation is authorized

Creating our first table

Choosing the columns

Creating a table

Choosing keys

Inserting data manually

Data entry panel tuning for CHAR and VARCHAR

Browse mode

SQL query links

Navigation bar

Query results operations

Displaying data as a chart

Sorting results

Headwords

Color-marking rows or columns

Limiting the length of each column

Display options

Browsing distinct values

Profiling queries

Creating an additional table

Summary

5. Changing Data and Structure

Changing data

Entering 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

Inline row editing

Deleting data

Deleting a single row

Deleting multiple rows

Deleting all of the rows in a table

Deleting all rows in multiple tables

Deleting tables

Deleting databases

Changing table structure

Adding a column

Vertical mode

Editing column attribute

TEXT column type

BLOB (Binary Large Object) column type

Uploading binary content

ENUM and SET column types

DATE, DATETIME, and TIMESTAMP column types

C...