- phpMyAdmin Tutorial
- phpMyAdmin - Home
- phpMyAdmin - Overview
- phpMyAdmin - Environment Setup
- phpMyAdmin - Features
- phpMyAdmin - Pros & Cons
- phpMyAdmin vs MySQL Workbench
- phpMyAdmin Sections
- phpMyAdmin - Databases
- phpMyAdmin - SQL
- phpMyAdmin - Status
- phpMyAdmin - User Accounts
- phpMyAdmin - Export
- phpMyAdmin - Import
- phpMyAdmin - Settings
- phpMyAdmin - Binary Logs
- phpMyAdmin - Replication
- phpMyAdmin - Variables
- phpMyAdmin - Charsets
- phpMyAdmin - Engines
- phpMyAdmin - Plugins
- phpMyAdmin Useful Resources
- phpMyAdmin - Quick Guide
- phpMyAdmin - Useful Resources
- phpMyAdmin - Discussion
phpMyAdmin - Features
Following is some of the key features of phpMyAdmin.
User friendly Web Interface − phpMyAdmin UI is quite intuitive and easy to use.
Most of Database Operations are supported − phpMyAdmin supports most of the MySQL/MariaDB features as listed below −
Browse databases, tables, view, fields and indexes.
Create/Copy/Drop/Rename databases, tables, view, fields and indexes.
Server maintenance, database/tables configuration proposal.
Execute, Edit and bookmark SQL statements, batch queries.
Manage user accounts and privilleges.
Manage stored procedures and triggers.
Import Data − Data can be imported from from CSV and SQL files.
Export Data − Data can be exported to various formats like CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX and others
Multiserver support − phpMyAdmin can be used to administrater multiple servers together.
Graphics Support − phpMyAdmin can show graphics of database layout in various formats.
Query-by-example − phpMyAdmin Query-by-example (QBE) can be used to create complex queries.
Search − phpMyAdmin allows to searching globally in a database or a subset of database.
Transformation − phpMyAdmin can help in transforming stored data into any format using a set of built-in functions, for example displaying BLOB-data as image or download-link.