05577nam 2200721 a 450 991046150250332120200520144314.01-280-15706-297866135417341-84951-779-7(CKB)2670000000148422(EBL)934511(OCoLC)785782416(SSID)ssj0000646693(PQKBManifestationID)11370962(PQKBTitleCode)TC0000646693(PQKBWorkID)10699432(PQKB)10680347(MiAaPQ)EBC934511(CaSebORM)9781849517782(PPN)228029864(Au-PeEL)EBL934511(CaPaEBR)ebr10533703(CaONFJC)MIL354173(OCoLC)780114239(EXLCZ)99267000000014842220120315d2012 uy 0engur|n|---|||||txtccrMastering phpMyAdmin 3.4 for effective MySQL management[electronic resource] a complete guide to getting started with phpMyAdmin 3.4 and mastering its features /Marc Delisle1st editionBirmingham Packt Pub.20121 online resource (394 p.)Community experience distilledIncludes index.1-84951-778-9 Cover; 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 fileAvoiding 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 SecurityLogging 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 rulesOrder 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 collationsNavigation 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 storageSaving in a fileThis 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 MyCommunity experience distilled.PHP (Computer program language)Web site developmentDatabase managementElectronic books.PHP (Computer program language)Web site development.Database management.005.7565Delisle Marc882992MiAaPQMiAaPQMiAaPQBOOK9910461502503321Mastering phpMyAdmin 3.4 for effective MySQL management2133691UNINA