• Complain

Marc Delisle - Mastering phpMyAdmin 3.4 for Effective MySQL Management

Here you can read online Marc Delisle - Mastering phpMyAdmin 3.4 for Effective MySQL Management full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2012, publisher: Packt Publishing, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Marc Delisle Mastering phpMyAdmin 3.4 for Effective MySQL Management
  • Book:
    Mastering phpMyAdmin 3.4 for Effective MySQL Management
  • Author:
  • Publisher:
    Packt Publishing
  • Genre:
  • Year:
    2012
  • Rating:
    5 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 100
    • 1
    • 2
    • 3
    • 4
    • 5

Mastering phpMyAdmin 3.4 for Effective MySQL Management: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Mastering phpMyAdmin 3.4 for Effective MySQL Management" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

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 toolphpMyAdminand 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. What you will learn from this book 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 tables 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 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.

Marc Delisle: author's other books


Who wrote Mastering phpMyAdmin 3.4 for Effective MySQL Management? Find out the surname, the name of the author of the book and a list of all author's works by series.

Mastering phpMyAdmin 3.4 for Effective MySQL Management — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Mastering phpMyAdmin 3.4 for Effective MySQL Management" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
Mastering phpMyAdmin 3.4 for Effective MySQL Management

Mastering phpMyAdmin 3.4 for Effective MySQL Management

Copyright 2012 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: February 2012

Production Reference: 1310112

Published by Packt Publishing Ltd. Livery Place 35 Livery Street Birmingham B3 2PB, UK.

ISBN 978-1-84951-778-2

www.packtpub.com

Cover Image by Michal iha (<>)

Credits

Author

Marc Delisle

Reviewers

Madhura Jayaratne

Rouslan Placella

Lead Technical Editors

Kartikey Pandey

Meeta Rajani

Technical Editor

Kedar Bhat

Project Coordinator

Jovita Pinto

Proofreader

Mario Cecere

Indexer

Tejal Daruwale

Production Coordinator

Arvindkumar Gupta

Cover Work

Arvindkumar Gupta

About the Author

Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin. He started to contribute to the project in December 1998, when he made the multi-language version. He is involved with phpMyAdmin as a developer, translator, and project administrator and enjoys meeting phpMyAdmin users in person.

Marc is a system administrator at Cegep de Sherbrooke, Qubec, Canada. He lives in Sherbrooke with his wife and they enjoy spending time with their four children.

In addition to the "Mastering phpMyAdmin" successive editions, Marc has written "Creating your MySQL Database: Practical Design Tips and Techniques" and "phpMyAdmin Starter" , also with Packt Publishing.

I am truly grateful to the Packt team whose sound comments were greatly appreciated during the production. My thanks also go to the reviewers of all editions; their sharp eyes helped in making this book clearer and more complete.

Finally, I wish to thank all contributors to phpMyAdmin's source code, translations, and documentation; their dedication to this project continues to push me forward.

About the Reviewers

Madhura Jayaratne is a Computer Science and Engineering graduate of University of Moratuwa. Currently he works as a software engineer and is located in Colombo, Sri Lanka.

He is a member of phpMyAdmin team and has contributed with GIS support for the software, which will be a part of its future releases. He continues to contribute by coding and translating the software.

Rouslan Placella , based in Cork, Ireland, is currently completing an Honors degree in Software Development at the Cork Institute of Technology. Born in Saint Petersbourg in 1985, his enthusiasm for programming and electronics was nurtured from a very early age. He is passionate about high performance and secure software and has been contributing to open source software with phpMyAdmin and Geeklog. During the summer of 2011 he took part in the Google Summer of Code program, where he developed an improved interface for MySQL routines, triggers, and events for phpMyAdmin. He currently also teaches Math and programming to second and third-level students.

www.PacktPub.com
Support files, eBooks, discount offers, and more

You might want to visit www.PacktPub.com for support files and downloads related to your book.

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at > for more details.

At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.

httpPacktLibPacktPubcom Do you need instant solutions to your IT - photo 1

http://PacktLib.PacktPub.com

Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books.

Why Subscribe?
  • Fully searchable across every book published by Packt
  • Copy and paste, print, and bookmark content
  • On demand and accessible via web browser
Free Access for Packt account holders

If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.

This book is dedicated to Carole, Andr, Corinne, Annie, and Guillaume, with all my love.

Preface

phpMyAdmin is an open source web interface that handles the administration of MySQL. It can perform various tasks such as creating, modifying, or deleting databases, tables, columns, or rows. It can also execute SQL statements or manage users and their permissions. When it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators search for tutorials to accomplish their tasks.

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 toolphpMyAdminand 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 book jump starts with installing and configuring phpMyAdmin, and then looks into phpMyAdmin's features. This is followed by configuring authentication in phpMyAdmin and setting parameters that influence the interface as a whole, including the new user preferences feature. You will first create two basic tables and then edit, delete data, tables, and databases. As backups are crucial to a project, you will create up-to-date backups and then look into importing the data that you have exported. You will also explore the various search mechanisms and query across multiple tables.

Now you will learn some advanced features such as defining inter-table relations, both with relation view and the Designer panel. Some queries are out of the scope of the interface; you will enter SQL command to accomplish these tasks.

You will also learn about synchronizing databases on different servers and managing MySQL replication to improve performance and data security. You will also store queries as bookmarks for their quick retrieval. Towards the end of the book you will learn to document your database, track changes made to the database, and manage user accounts using phpMyAdmin server management features.

Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Mastering phpMyAdmin 3.4 for Effective MySQL Management»

Look at similar books to Mastering phpMyAdmin 3.4 for Effective MySQL Management. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «Mastering phpMyAdmin 3.4 for Effective MySQL Management»

Discussion, reviews of the book Mastering phpMyAdmin 3.4 for Effective MySQL Management and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.