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

• Record Nr.: UNINA9910456630203321
• Autore: Delisle Marc
• Pubbl/distr/stampa: Birmingham, U.K., : Packt Pub., 2009
• ISBN: 1-282-06329-4; 9786612063299; 1-84719-787-6
• Descrizione fisica: 1 online resource (352 p.)
• Collana: From technologies to solutions
• Disciplina: 005.75
• Soggetti: PHP (Computer program language); Electronic books.
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• 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