LEADER 04887nam 2200637 a 450 001 9910456630203321 005 20200520144314.0 010 $a1-282-06329-4 010 $a9786612063299 010 $a1-84719-787-6 035 $a(CKB)2430000000015666 035 $a(EBL)967845 035 $a(OCoLC)799762965 035 $a(SSID)ssj0000348708 035 $a(PQKBManifestationID)12084512 035 $a(PQKBTitleCode)TC0000348708 035 $a(PQKBWorkID)10346034 035 $a(PQKB)10180405 035 $a(MiAaPQ)EBC967845 035 $a(PPN)227997409 035 $a(Au-PeEL)EBL967845 035 $a(CaPaEBR)ebr10456231 035 $a(CaONFJC)MIL206329 035 $a(EXLCZ)992430000000015666 100 $a20110408d2009 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMastering phpMyAdmin 3.1 for effective MySQL management$b[electronic resource] $eincrease your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1 /$fMarc Delisle 210 $aBirmingham, U.K. $cPackt Pub.$d2009 215 $a1 online resource (352 p.) 225 1 $aFrom technologies to solutions 300 $aIncludes index. 311 $a1-84719-786-8 327 $aCover; 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 327 $aManual 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 327 $aArbitrary 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 327 $aMySQL 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 327 $aIcons 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 327 $aEdit mode 330 $aIncrease your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1 410 0$aFrom technologies to solutions. 606 $aPHP (Computer program language) 608 $aElectronic books. 615 0$aPHP (Computer program language) 676 $a005.75 700 $aDelisle$b Marc$0882992 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910456630203321 996 $aMastering phpMyAdmin 3.1 for effective MySQL management$91972442 997 $aUNINA