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

€22.99 ~~€25.99~~

4.3 (10 Ratings)

eBook Feb 2012 394 pages 1st Edition

€22.99 ~~€25.99~~

eBook Feb 2012 394 pages 1st Edition

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Preview Book

Key benefits

A step-by-step tutorial for manipulating data with the latest version of phpmyadmin
Administer your MySQL databases with phpMyAdmin
Manage users and privileges with MySQL Server Administration tools
Learn to do things with your MySQL database and phpMyAdmin that you didn't know were possible!

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.

Who is this book 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.

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

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Frequently bought together

€19.99

€32.99

Responsive Web Design with HTML5 and CSS3

€32.99

Total € 85.97

Filter reviews by

All

Amazon verified reviews

Bob Jun 02, 2016

Extremely satisfied with the product and the seller.

Amazon Verified review

J. Gwinn Dec 19, 2014

I am new to phpMyAdmin and MySQL; however, I do have a background in developing MS Access databases and using SQL and VBA. Bottom line, this book was well written and the presentation of the code was easy for me to follow and use. Whether you are a beginner or seasoned programmer, you can gain an excellent understanding of how phpMyAdmiin and MySQL works.

Kevin Roberts Jul 11, 2012

If you've used MySQL on any shared hosting platform, you've likely done your database administration with some version of phpMyAdmin, an application developed in PHP with some JavaScript providing UI polish. Mastering phpMyAdmin is an ideal resource.The book is very well organized, and provides a good introduction to MySQL while it covers phpMyAdmin in detail, so it works well as both the "missing manual" for phpMyAdmin and as a resource for anyone wanting to learn MySQL. The text is well-paced and consistently good at explaining what is occurring when a particular phpMyAdmin operation is invoked.There are a few awkward phrases here and there in the text that I suspect betray the fact that English is not the author's first language (e.g. telling people that we are "over viewing" a topic), however such instances are few, and the quality of the English writing overall is very good. I just wish the text used "you" instead of "we" when explaining everything since the latter doesn't seem as natural to me.The first two chapters cover the details of how to install and configure phpMyAdmin (including how to secure it), and chapter three takes you through everything you need to know about the user interface. Subsequent chapters deal with how to manipulate MySQL databases using phpMyAdmin, however the author does not give a dry screen-capture run-through of all the screens. He instead explains the purpose of them with practical examples.Chapters four and five introduce creating and manipulating MySQL tables, and a provides good explanations of basic column types.Chapters six and seven take you through exporting and importing data with detailed examples and explanations of the various import and export types.Chapters eight and nine introduce database queries and table operations.Chapter ten introduces relational operations, referential integrity, and alternative storage engines.Chapters eleven and twelve introduces SQL syntax, the query window, multi-table queries, and the (new to me) visual query builder that became available in version 3.4 of phpMyAdmin.Chapter thirteen gets into synchronizing and replicating databases, and setting up a test environment.Chapter fourteen introduces query bookmarks.Chapter fifteen deals with phpMyAdmin features for documenting your database systemChapter sixteen shows you how to transform the display format of your MySQL quey results using MIME.Chapter seventeen looks at how phpMyAdmin supports new MySQL 5 features (views, stored procedures, triggers, partitions, scheduler, etc.)Chapter eighteen covers phpMyAdmin support for logging transaction.Chapter nineteen covers server administration tasks.Mastering phpMyAdmin provides complete coverage of the phpMyAdmin application, and is a great introdcution to MySQL for novices. It really is the "missing manual" for phpMyAdmin (I find the documentation on the phpMyAdmin website too spartan).

Bishop Berkeley Apr 20, 2016

Good book.

mko Apr 03, 2012

This book is really a good read. First off all, it will guide your through all the odds and ends of phpMyAdmin. In case you have never ever worked with this tool before, there is no better place to start.Marc shows various aspects of phpMyAdmin basing his book on a tutorial like convention. All you have to do is to understand what he says, and follow his steps. This way, after reading the book, you will have your own copy of phpMyAdmin ready to go. As this book is an easy to follow by beginners it may be slightly boring for advanced phpMyAdmin admins who are looking for phpMyAdmin reference.I am giving five here, even though I would expect more condensed content. However, this book is advertised (at the cover) as book for beginners. It is exactly as cover says - the book is an easy, gentle, and comprehensive introduction to phpMyAdmin.

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

What do you get with eBook?