04887nam 2200637 a 450 991045663020332120200520144314.01-282-06329-497866120632991-84719-787-6(CKB)2430000000015666(EBL)967845(OCoLC)799762965(SSID)ssj0000348708(PQKBManifestationID)12084512(PQKBTitleCode)TC0000348708(PQKBWorkID)10346034(PQKB)10180405(MiAaPQ)EBC967845(PPN)227997409(Au-PeEL)EBL967845(CaPaEBR)ebr10456231(CaONFJC)MIL206329(EXLCZ)99243000000001566620110408d2009 uy 0engur|n|---|||||txtccrMastering 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 DelisleBirmingham, U.K. Packt Pub.20091 online resource (352 p.)From technologies to solutionsIncludes index.1-84719-786-8 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 scriptManual 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 fileArbitrary 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 footerMySQL 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 viewIcons 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 DataEdit modeIncrease your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1From technologies to solutions.PHP (Computer program language)Electronic books.PHP (Computer program language)005.75Delisle Marc882992MiAaPQMiAaPQMiAaPQBOOK9910456630203321Mastering phpMyAdmin 3.1 for effective MySQL management1972442UNINA