Introduction

phpMyAdmin is a free software tool written in PHP that is intended to handle the
administration of a MySQL or MariaDB database server. You can use phpMyAdmin to
perform most administration tasks, including creating a database, running queries,
and adding user accounts.

Supported features

Currently phpMyAdmin can:

  • create, browse, edit, and drop databases, tables, views, columns, and indexes

  • display multiple results sets through stored procedures or queries

  • create, copy, drop, rename and alter databases, tables, columns and
    indexes

  • maintenance server, databases and tables, with proposals on server
    configuration

  • execute, edit and bookmark any SQL-statement, even batch-queries

  • load text files into tables

  • create 1 and read dumps of tables

  • export 1 data to various formats: CSV, XML, PDF,
    ISO/IEC 26300 – OpenDocument Text and Spreadsheet, Microsoft
    Word 2000, and LATEX formats

  • import data and MySQL structures from OpenDocument spreadsheets, as
    well as XML, CSV, and SQL files

  • administer multiple servers

  • add, edit, and remove MySQL user accounts and privileges

  • check referential integrity in MyISAM tables

  • using Query-by-example (QBE), create complex queries automatically
    connecting required tables

  • create PDF graphics of your
    database layout

  • search globally in a database or a subset of it

  • transform stored data into any format using a set of predefined
    functions, like displaying BLOB-data as image or download-link

  • track changes on databases, tables and views

  • support InnoDB tables and foreign keys

  • support mysqli, the improved MySQL extension see 1.17 Which Database versions does phpMyAdmin support?

  • create, edit, call, export and drop stored procedures and functions

  • create, edit, export and drop events and triggers

  • communicate in 80 different languages

Shortcut keys

Currently phpMyAdmin supports following shortcuts:

  • k – Toggle console

  • h – Go to home page

  • s – Open settings

  • d + s – Go to database structure (Provided you are in database related page)

  • d + f – Search database (Provided you are in database related page)

  • t + s – Go to table structure (Provided you are in table related page)

  • t + f – Search table (Provided you are in table related page)

  • backspace – Takes you to older page.

A word about users

Many people have difficulty understanding the concept of user
management with regards to phpMyAdmin. When a user logs in to
phpMyAdmin, that username and password are passed directly to MySQL.
phpMyAdmin does no account management on its own (other than allowing
one to manipulate the MySQL user account information); all users must
be valid MySQL users.

Footnotes

1(1,2)

phpMyAdmin can compress (ZIP, GZip or RFC 1952
formats) dumps and CSV exports if you use PHP with
Zlib support (--with-zlib).
Proper support may also need changes in php.ini.