Mastering phpMyAdmin 3.4 for effective MySQL management : a complete guide to getting started with phpMyAdmin 3.4 and mastering its features / Marc Delisle.

Format:

Book

Author/Creator:

Delisle, Marc.

Series:

Community experience distilled.

Community experience distilled

Language:

English

Subjects (All):

Apache (Computer file : Apache Group).

MySQL (Electronic resource).

PHP (Computer program language).

Web site development.

Database management.

Physical Description:

1 online resource (394 p.)

Edition:

1st edition

Place of Publication:

Birmingham : Packt Pub., 2012.

Language Note:

English

System Details:

text file

Summary:

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

Contents:

Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Getting Started with phpMyAdmin; PHP and MySQL: The leading open source duo; What is phpMyAdmin?; Project documentation; Installing phpMyAdmin; Required information; System requirements; Downloading the files; Installing on different platforms; Installing on a remote server using a Windows client; Installing on a local Linux server; Installing on a local Windows server (Apache, IIS); Configuring phpMyAdmin; The config.inc.php file

Avoiding false error messages about permissions on config.inc.phpConfiguration principles; Web-based setup script; Manually creating config.inc.php; Tips for editing config.inc.php on a Windows client; Description of some configuration parameters; PmaAbsoluteUri; Server-specific sections; Installing phpMyAdmin configuration storage; Goal of the configuration storage; Location of the configuration storage; Performing the installation; Installing for a single user; Installing for multiple users; Upgrading phpMyAdmin; Summary; Chapter 2:Configuring Authentication and Security

Logging in to MySQL through phpMyAdminLogging in to an account without a password; Authenticating a single user with config; Testing the MySQL connection; Authenticating multiple users; Authenticating with HTTP; Authenticating with cookie values; Authenticating with signon mode; Configuring for multiple server support; Defining servers in the configuration file; Authenticating through an arbitrary server; Logging out; Securing phpMyAdmin; Protecting phpMyAdmin at directory level; Displaying error messages; Protecting with IP-based access control; Defining rules

Order of interpretation for rulesBlocking root access; Protecting in-transit data; Summary; Chapter 3:Over Viewing the Interface; Over viewing panels and windows; Login panels; Navigation and main panels; Home page; Views; Query window; Starting page; Customizing general settings; Configuring window title; Natural sort order for database and table names; Creating site-specific header and footer; Themes; Configuring themes; Selecting themes; Selecting a language; Slider; Restricting the list of databases; Deactivating Ajax; Character sets and collations; Effective character sets and collations

Navigation panelConfiguring the logo; Database and table list; Light mode; Full mode; Table abridged statistics; Table quick-access icon; Nested display of tables within a database; Counting the number of tables; Choosing from the server list; Handling many databases or tables; Limits on the interface; Improving fetch speed; Main panel; Home page; Database view; Table view; Server view; Icons for home page and menu tabs; Opening a new phpMyAdmin window; User preferences; Accessing user preferences; Possible locations for saving preferences; Saving in phpMyAdmin configuration storage

Saving in a file

Notes:

Includes index.

ISBN:

9786613541734

9781280157066

1280157062

9781849517799

1849517797

OCLC:

785782416