+ +
+

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.
+
+
+ + +