Mastering phpMyAdmin 3.3.x for effective MySQL management [[electronic resource] ] : a complete guide to getting started with phpMyAdmin 3.3 and mastering its features / / Marc Delisle

• Record Nr.: UNINA9910459108203321
• Autore: Delidle Marc
• Pubbl/distr/stampa: Birmingham, U.K., : Packt Pub., 2010
• ISBN: 1-282-88218-X; 9786612882180; 1-84951-355-4
• Descrizione fisica: 1 online resource (412 p.)
• Disciplina: 005.7565
• Soggetti: PHP (Computer program language); Web site development; Database management; Electronic books.
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.
• Nota di contenuto: 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; Icons for the home page and menu tabs
• Sommario/riassunto: A complete guide to get started with phpMyAdmin 3.3 and master its features