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