Packt Publishing Mastering phpMyAdmin 2.11 for Effective MySQL Management (2008).pdf

(7559 KB) Pobierz
Mastering phpMyAdmin 2.11 for
Effective MySQL Management
Increase your MySQL productivity and control by
discovering the real power of phpMyAdmin 2.11
Marc Delisle
BIRMINGHAM - MUMBAI
 
993034006.014.png 993034006.015.png 993034006.016.png 993034006.001.png 993034006.002.png 993034006.003.png 993034006.004.png
Mastering phpMyAdmin 2.11 for Effective
MySQL Management
Copyright © 2008 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 authors, Packt Publishing,
nor its dealers or 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 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: March 2008
Production Reference: 1110308
Published by Packt Publishing Ltd.
32 Lincoln Road
Olton
Birmingham, B27 6PA, UK.
ISBN 978-1-847194-18-3
www.packtpub.com
Cover Image by Bruno Abarca ( bruno.granada@gmail.com )
993034006.005.png
Table of Contents
Preface
1
Chapter 1: Introducing phpMyAdmin
7
PHP and MySQL: The Leading Open-Source Duo
8
What is phpMyAdmin?
8
History
9
Awards
13
phpMyAdmin Features Summary
13
Summary
15
Chapter 2: Installing phpMyAdmin
17
System Requirements
18
GoPHP5
18
Downloading the Files
18
Installation
19
Installation on a Remote Server Using a Windows Client
19
Installation on a Local Linux Server
20
Installation on Local Windows Servers (Apache, IIS)
20
First Connection Configuration
21
Configuration Principles
21
Web-Based Setup Script
22
Manual Creation of config.inc.php
27
Tips for Editing config.inc.php on a Windows Client
27
The config.inc.php File
27
PmaAbsoluteUri
28
Server-Specific Sections
28
extension
29
PersistentConnections
29
connect_type, socket and port
29
compress Configuration
30
Authentication Type: config
30
993034006.006.png 993034006.007.png 993034006.008.png
 
Table of Contents
Testing the First Connection
31
Multi-Server Configuration
31
Servers Defined in the Configuration File
31
Arbitrary Server
32
Advanced Authentication
33
Authentication Types Offered
33
The Control User
33
Logging Out
34
HTTP Authentication
34
Cookie Authentication
35
Signon
36
Security
37
Directory-Level Protection
37
IP-Based Access Control
38
Rules
38
Order of Interpretation for Rules
39
Simplified Rule for Root Access
40
Restricting the List of Databases
40
Protecting In-Transit Data
41
Upgrading phpMyAdmin
41
Summary
42
Chapter 3: Interface Overview
43
Panels and Windows
43
Login Panels
43
Left and Right Panels
43
Home Page
44
Views
44
Query Window
45
Starting Page
45
Window Titles Configuration
45
General Icon Configuration
45
Natural Sort Order for Database and Table Names
46
Language Selection
46
Themes
48
Theme Configuration
48
Theme Selection
49
Left Panel
49
Logo Configuration
50
Database and Table List
50
Light Mode
51
Full Mode
53
Table Short Statistics
54
993034006.009.png 993034006.010.png
 
Table of Contents
Quick-Browsing a Table
54
Nested Display of Tables within a Database
54
Server-List Choice
56
Handling Many Databases or Tables
56
Right Panel
57
Home Page
58
Database View
59
Table View
61
Server View
62
Icons for Home Page and Menu Tabs
62
Query Window
63
Site-Specific Header and Footer
64
MySQL Documentation Links
64
Summary
64
Chapter 4: First Steps
65
Database Creation
65
No Privileges?
65
First Database Creation Is Authorized
66
Creating Our First Table
68
Choosing the Fields
68
Table Creation
68
Choosing Keys
70
Manual Data Insertion
72
Data Entry Panel Tuning for CHAR and VARCHAR
74
Browse Mode
75
SQL Query Links
76
Navigation Bar
77
Query Results Operations
79
Sorting Results
80
Color-Marking Rows
81
Limiting the Length of Each Column
81
Browsing Distinct Values
82
Browse-Mode Customization
83
Creating an Additional Table
83
Summary
84
Chapter 5: Changing Data
85
Edit Mode
85
Moving to Next Field with the Tab Key
86
Moving with Arrows
87
Handling NULL Values
87
993034006.011.png 993034006.012.png 993034006.013.png
 

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin