Mastering phpMyAdmin 3.1 for effective MySQL management [[electronic resource] ] : increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1 / / Marc Delisle

• Autore: Delisle Marc
• Pubblicazione: Birmingham, U.K., : Packt Pub., 2009
• Descrizione fisica: 1 online resource (352 p.)
• Disciplina: 005.75
• Soggetto topico: PHP (Computer program language)
• Soggetto genere / forma: Electronic books.
• Note generali: Includes index.
• Nota di contenuto: Cover; Table of Contents; Preface; Chapter 1: Introduction and Installation; Introducing phpMyAdmin; Web applications; PHP and MySQL:The leading open source duo; What is phpMyAdmin?; phpMyAdmin features; Installing phpMyAdmin; Required information; System requirements; Downloading the files; Installation procedure; Installation on a remote server using a Windows client; Installation on a local Linux server; Installation on local Windows servers (Apache, IIS); Configuring phpMyAdmin; The config.inc.php file; Permissions on config.inc.php; Configuration principles; Web-based setup script ; Manual creation of config.inc.phpTips for editing config.inc.php on a Windows Client; Description of some configuration parameters; PmaAbsoluteUri; Server-specific sections; Upgrading phpMyAdmin; Summary; Chapter 2: Authentication and Security; MySQL authentication; Root user without password; Single-user authentication using config; Testing the connection; Multi-user authentication; Authentication types offered; The control user; Logging out; HTTP authentication; Cookie authentication; Signon authentication; Multi-server configuration; Servers defined in the configuration file ; Arbitrary serverSecurity; Directory-level protection; Error handling; IP-based access control; Rules; Order of interpretation for rules; Simplified rule for root access; Restricting the list of databases; Protecting in-transit data; Swekey hardware authentication; Configuration; Usage; Security note; Summary; Chapter 3: Interface Overview; Panels and windows; Login panels; Left and right panels; Homepage; Views; Query window; Starting page; General customization; Window titles configuration; Icon configuration; Natural sort order for database and table names; Site-specific header and footer ; MySQL documentation linksThemes; Theme configuration; Theme selection; The color picker; Sliders; Character sets, collations and language; Collations; Unicode and UTF-8; Language selection; Effective character sets and collations; Left panel (navigation); Logo configuration; Database and table list; Light mode; Full mode; Table short statistics; Table quick-access icon; Nested display of tables within a database; Server-list choice; Handling many databases or tables; Limits on the interface; Improving fetch speed; Right panel (main); Homepage; Database view; Table view; Server view ; Icons for homepage and menu tabsQuery window; Summary; Chapter 4: First Steps; Database creation; No privileges?; First database creation is authorized; Creating our first table; Choosing the fields; Table creation; Choosing keys; Manual data insertion; Data entry panel tuning for CHAR and VARCHAR; Browse mode; SQL query links; Navigation bar; Query results operations; Sorting results; Headwords; Color-marking rows; Limiting the length of each column; Display options; Browsing distinct values; Browse-mode customization; Creating an additional table; Summary; Chapter 5: Changing Data ; Edit mode
• Sommario/riassunto: Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1
• Titolo autorizzato: Mastering phpMyAdmin 3.1 for effective MySQL management
• ISBN: 1-282-06329-4; 9786612063299; 1-84719-787-6
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910456630203321
• Lo trovi qui: Univ. Federico II
• Serie: From technologies to solutions.