Mastering phpMyAdmin 3.4 for effective MySQL management a complete guide to getting started with phpMyAdmin 3.4 and mastering its features
This 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 databa...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub
2012.
|
| Edición: | 1st edition |
| Colección: | Community experience distilled.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628314906719 |
Tabla de Contenidos:
- 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 file
- Avoiding 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
- Logging 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
- Order 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
- Navigation 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
- Saving in a file
