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.