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

A complete guide to get started with phpMyAdmin 3.3 and master its features.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Delisle, Marc
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, U.K. : Packt Pub., ©2010.
Temas:
Apache (Computer file : Apache Group)
MySQL (Electronic resource)
PHP (Computer program language)
Web site development.
Database management.
PHP (Langage de programmation)
Sites Web > Développement.
Bases de données > Gestion.
COMPUTERS > Programming Languages > SQL.
Database management
Web site development
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Cover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting Started with phpMyAdmin; Introducing phpMyAdmin; Web applications; 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 machine; Installing on a local Linux server; Installing on local Windows servers (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; Persistent Connections; Upgrading phpMyAdmin; Summary; Chapter 2: Configuring Authentication and Security; Logging in to MySQL through phpMyAdmin; Logging in to an account without a password; Authenticating a single user with config; Testing the MySQL connection; Authenticating multiple users
  • Authentication types offered The control user; Logging out; Authenticating with HTTP; Authenticating users with cookie values; Authenticating through the sign on mode; Configuring for multiple server support; Defining servers in the configuration file; Authenticating through an arbitrary server; Securing phpMyAdmin; Protecting phpMyAdmin at the directory level; Displaying error messages; Protecting with IP-based access control; Defining rules; Order of interpretation for rules; Blocking root access; Protecting in-transit data; Authenticating using Swekey hardware
  • Configuring Swekey authentication Using phpMyAdmin in a Swekey context; Security note; Access logging; Available information; Configuring Apache; 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 the window title; Configuring icons; Natural sort order for database and table names; Creating site-specific headers and footers; Displaying MySQL documentation links; Themes; Configuring themes; Selecting themes
  • Assigning colors using the color picker Sliders; Limiting URL lengths; Restricting the list of databases; Character sets, collations, and language; Collations; Unicode and UTF-8; Selecting languages; Effective character sets and collations; Navigation panel; Configuring the logo; Database and table list; Light mode; Full mode; Table short statistics; Table quick-access icon; Nested display of tables within a database; 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

Ejemplares similares