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 psted 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 pke 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-pnk.