LEADER 05577nam 2200721 a 450 001 9910461502503321 005 20200520144314.0 010 $a1-280-15706-2 010 $a9786613541734 010 $a1-84951-779-7 035 $a(CKB)2670000000148422 035 $a(EBL)934511 035 $a(OCoLC)785782416 035 $a(SSID)ssj0000646693 035 $a(PQKBManifestationID)11370962 035 $a(PQKBTitleCode)TC0000646693 035 $a(PQKBWorkID)10699432 035 $a(PQKB)10680347 035 $a(MiAaPQ)EBC934511 035 $a(CaSebORM)9781849517782 035 $a(PPN)228029864 035 $a(Au-PeEL)EBL934511 035 $a(CaPaEBR)ebr10533703 035 $a(CaONFJC)MIL354173 035 $a(OCoLC)780114239 035 $a(EXLCZ)992670000000148422 100 $a20120315d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMastering phpMyAdmin 3.4 for effective MySQL management$b[electronic resource] $ea complete guide to getting started with phpMyAdmin 3.4 and mastering its features /$fMarc Delisle 205 $a1st edition 210 $aBirmingham $cPackt Pub.$d2012 215 $a1 online resource (394 p.) 225 1 $aCommunity experience distilled 300 $aIncludes index. 311 $a1-84951-778-9 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Getting Started with phpMyAdmin; 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 platforms; Installing on a remote server using a Windows client; Installing on a local Linux server; Installing on a local Windows server (Apache, IIS); Configuring phpMyAdmin; The config.inc.php file 327 $aAvoiding false error messages about permissions on config.inc.phpConfiguration 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; Installing phpMyAdmin configuration storage; Goal of the configuration storage; Location of the configuration storage; Performing the installation; Installing for a single user; Installing for multiple users; Upgrading phpMyAdmin; Summary; Chapter 2:Configuring Authentication and Security 327 $aLogging in to MySQL through phpMyAdminLogging in to an account without a password; Authenticating a single user with config; Testing the MySQL connection; Authenticating multiple users; Authenticating with HTTP; Authenticating with cookie values; Authenticating with signon mode; Configuring for multiple server support; Defining servers in the configuration file; Authenticating through an arbitrary server; Logging out; Securing phpMyAdmin; Protecting phpMyAdmin at directory level; Displaying error messages; Protecting with IP-based access control; Defining rules 327 $aOrder of interpretation for rulesBlocking root access; Protecting in-transit data; Summary; Chapter 3:Over Viewing the Interface; Over viewing panels and windows; Login panels; Navigation and main panels; Home page; Views; Query window; Starting page; Customizing general settings; Configuring window title; Natural sort order for database and table names; Creating site-specific header and footer; Themes; Configuring themes; Selecting themes; Selecting a language; Slider; Restricting the list of databases; Deactivating Ajax; Character sets and collations; Effective character sets and collations 327 $aNavigation panelConfiguring the logo; Database and table list; Light mode; Full mode; Table abridged statistics; Table quick-access icon; Nested display of tables within a database; Counting the number of tables; Choosing from the server list; Handling many databases or tables; Limits on the interface; Improving fetch speed; Main panel; Home page; Database view; Table view; Server view; Icons for home page and menu tabs; Opening a new phpMyAdmin window; User preferences; Accessing user preferences; Possible locations for saving preferences; Saving in phpMyAdmin configuration storage 327 $aSaving in a file 330 $aThis is a step-by-step instructional guide to get you started easily with phpMyAdmin and teach you to manage and perform database functions on your database. You will first be introduced to the interface and then build basic tables and perform both simple and advanced functions on the created database. The book progresses gradually and you will follow it best by reading it sequentially. If you are a developer, system administrator, or web designer who wants to manage MySQL databases and tables efficiently, then this book is for you. This book assumes that you are already wellacquainted with My 410 0$aCommunity experience distilled. 606 $aPHP (Computer program language) 606 $aWeb site development 606 $aDatabase management 608 $aElectronic books. 615 0$aPHP (Computer program language) 615 0$aWeb site development. 615 0$aDatabase management. 676 $a005.7565 700 $aDelisle$b Marc$0882992 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910461502503321 996 $aMastering phpMyAdmin 3.4 for effective MySQL management$92133691 997 $aUNINA