Cargando…
Mastering phpMyAdmin 3.3.x for Effective MySQL Management.
A complete guide to get started with phpMyAdmin 3.3 and master its features.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2010.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Mastering phpMyAdmin 3.3.x for Effective MySQL Management; Mastering phpMyAdmin 3.3.x for Effective MySQL Management; Credits; About the Author; About the Reviewers; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 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 platformsInstalling 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.php; Configuration 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; extension; connect_type, socket, and port; compress configuration.
- PersistentConnectionsUpgrading phpMyAdmin; Summary; 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 signon mode; Configuring for multiple server support; Defining servers in the configuration file; Authenticating through an arbitrary server.
- Securing phpMyAdminProtecting 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; 3. Over Viewing the Interface; Over viewing panels and windows; Login panels; Navigation and main panels; Query window; Starting page; Home page; Views.
- Customizing general settingsConfiguring 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.