Mastering phpMyAdmin 3.1 for Effective MySQL Management

Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1
Code Files

Mastering phpMyAdmin 3.1 for Effective MySQL Management

Marc Delisle

Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1
Mapt Subscription
FREE
$30.00/m after trial
eBook
$14.70
RRP $20.99
Save 29%
Print + eBook
$34.99
RRP $34.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
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
$14.70
$34.99
$29.99 p/m after trial
RRP $20.99
RRP $34.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Mastering phpMyAdmin 3.1 for Effective MySQL Management Book Cover
Mastering phpMyAdmin 3.1 for Effective MySQL Management
$ 20.99
$ 14.70
Getting Started with NoSQL Book Cover
Getting Started with NoSQL
$ 14.99
$ 10.50
Buy 2 for $25.20
Save $10.78
Add to Cart

Book Details

ISBN 139781847197863
Paperback352 pages

Book Description

MySQL has gained wide popularity because of its open-source nature, performance, reliability, robustness, and support for various platforms.

phpMyAdmin is a web-based front-end to manage MySQL databases and has been adopted by a number of open-source distributors. It is one of the most widely used open-source applications 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. The powerful graphical interface of version 3.1 has made phpMyAdmin an indispensable tool for MySQL and web developers.

This is the first book that covers version 3.1, the latest version of phpMyAdmin. It has been fully updated from the previous version that covered phpMyAdmin Version 2.11. It is a comprehensive guide to unlocking the full potential of phpMyAdmin. It builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet right from showing you how to set up and manage the database with clear, step-by-step instructions and screenshots to exploring the less well known and generally under-used features and capabilities of phpMyAdmin in depth. Along the way you'll build a more detailed understanding of SQL and how it works in MySQL.

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

Table of Contents

Chapter 2: Authentication and Security

What You Will Learn

  • Administer MySQL users and get statistics about MySQL servers and databases
  • Create better database tables and relational structures
  • Generate multiple SQL queries and build a more detailed understanding of SQL and its workings
  • Prepare better documentation of evolving table structures
  • Manage databases, table data and structures, and indexes to create efficient databases
  • Learn the different mechanisms involved in importing SQL and CSV files
  • Examine the modified behavior of phpMyAdmin to use the outstanding application to its full power
  • Perform day-to-day database and table management effectively with the new interface to ease your work

Authors

Table of Contents

Chapter 2: Authentication and Security

Book Details

ISBN 139781847197863
Paperback352 pages
Read More

Read More Reviews

Recommended for You

Getting Started with NoSQL Book Cover
Getting Started with NoSQL
$ 14.99
$ 10.50
Mobile First Design with HTML5 and CSS3 Book Cover
Mobile First Design with HTML5 and CSS3
$ 20.99
$ 14.70
HTML5 Video How-To Book Cover
HTML5 Video How-To
$ 12.99
$ 9.10
JavaScript Testing Beginner's Guide  Book Cover
JavaScript Testing Beginner's Guide
$ 26.99
$ 18.90
EVE Online: ISK Strategy Guide Book Cover
EVE Online: ISK Strategy Guide
$ 17.99
$ 12.60
HTML5 Web Application Development By Example : Beginner's guide Book Cover
HTML5 Web Application Development By Example : Beginner's guide
$ 26.99
$ 18.90