Mastering phpMyAdmin 3.4 for Effective MySQL Management

A complete guide to getting started with phpMyAdmin 3.4 and mastering its features book and ebook
Code Files

Mastering phpMyAdmin 3.4 for Effective MySQL Management

Marc Delisle

A complete guide to getting started with phpMyAdmin 3.4 and mastering its features book and ebook
Packt Subscription
FREE
$9.99/m after trial
eBook
$16.80
RRP $23.99
Save 29%
Print + eBook
$39.99
RRP $39.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$16.80
$39.99
$0 p/m after trial
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 10 Day Trial

Frequently bought together


Mastering phpMyAdmin 3.4 for Effective MySQL Management Book Cover
Mastering phpMyAdmin 3.4 for Effective MySQL Management
$ 23.99
$ 16.80
Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
Buy 2 for $25.20
Save $10.78
Add to Cart

Book Details

ISBN 139781849517782
Paperback394 pages

Book Description

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

Chapter 2: Configuring Authentication and Security
Chapter 5: Changing Data and Structure
Chapter 13: Synchronizing Data and Supporting Replication

What You Will Learn

  • Upload phpMyAdmin to your web server and upgrade to the latest version
  • Protect authentication credentials according to the needs of a users group
  • Manage multiple MySQL servers using a single copy of phpMyAdmin
  • Export a table's structure and data for backup purposes
  • Define inter-table relations in a relational system
  • Enter your own SQL queries to perform actions that are beyond the scope of the interface and keep a history of these queries
  • Administer users accounts and privileges
  • Troubleshoot common problems encountered in phpMyAdmin and avoid these problems from re-occurring

 

Authors

Table of Contents

Chapter 2: Configuring Authentication and Security
Chapter 5: Changing Data and Structure
Chapter 13: Synchronizing Data and Supporting Replication

Book Details

ISBN 139781849517782
Paperback394 pages
Read More

Read More Reviews

Recommended for You

Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
MySQL Management and Administration with Navicat Book Cover
MySQL Management and Administration with Navicat
$ 17.99
$ 12.60
Dreamweaver CS5.5 Mobile and Web Development with HTML5, CSS3, and jQuery Book Cover
Dreamweaver CS5.5 Mobile and Web Development with HTML5, CSS3, and jQuery
$ 23.99
$ 16.80
Mastering phpMyAdmin for Effective MySQL Management  Book Cover
Mastering phpMyAdmin for Effective MySQL Management
$ 23.99
$ 16.80
Dominar phpMyAdmin para una administración efectiva de MySQL [Espanol] Book Cover
Dominar phpMyAdmin para una administración efectiva de MySQL [Espanol]
$ 23.99
$ 16.80
Network Backup with Bacula How-To Book Cover
Network Backup with Bacula How-To
$ 14.99
$ 10.50