Get started with this quick introduction to phpMyAdmin, its
features, and the community
BIRMINGHAM - MUMBAI
Copyright © 2011 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 thepublisher,
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 liablefor 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: September 2011
Production Reference: 1050811Published by Packt Publishing Ltd.
35 Livery Street
Birmingham B3 2PB, UK.
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
filesavailable? You can upgrade to the eBook version at www.PacktPub.com and as a print book
customer, you are entitled to a discount on the eBook copy. Get in touch with us at service@
packtpub.com 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.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.
Ê Fully searchable across every book published by Packt
Ê Copy and paste, print and bookmark content
Ê On demand and accessible via webbrowser
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.
Table of Contents
So, what is phpMyAdmin?
Step 1—What do I need?
Step 3—Configuring phpMyAdmin
Step 4—Uploading to your web server
And that's it!!
Quick start—Creating your first tables
Step 1—Creating a database
Step 2—Opening the database
Step 3—Creating the first table
Step 4—Creating the second table
Step 5—Populating the tables
Top tasks you'll want to know about
Task 1—Browsing data
Task 2—Searching dataTask 3—Changing data and structure
Task 4—Exporting to Excel
Task 5—Creating relations
People and places you should get to know
Articles and tutorials
Welcome to the phpMyAdmin Starter. This book has been especially createdto provide you with all the information that you need to get set up with
phpMyAdmin. You will learn the basics of phpMyAdmin, get started with creating
your own tables, and discover some tips and tricks for using phpMyAdmin.
This document contains the following sections:
So what is phpMyAdmin? – find out what phpMyAdmin actually is, what you can do
with it, and why it’s so great....