About

phpMyAdmin is an open source tool written in php intended to handle the administration of mysql over the Web. In other words, it allows you to handle MySQL via the web browser in a visual format, with no need to write complex commands from the command line. It can perform various tasks such as creating, reading, updating or deleting databases, tables, columns or rows (crud); executing sql statements; or managing users and permissions.

Since the version 4.0.0-alpha1, the HTML frames are gone and the navigation panel now presents a tree.

Features

• Features provided by the program include:

• Web interface

• MySQL database management

• Import data from CSV and SQL

• Export data to various formats: CSV, SQL, XML, PDF (via the TCPDF
  library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word,
  Excel, LaTeX and others

• Administering multiple servers

• Creating PDF graphics of the database layout

• Creating complex queries using Query-by-Example (QBE)

• Searching globally in a database or a subset of it

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

• Live charts to monitor MySQL server activity like connections,
  processes, CPU/Memory usage, etc.

• Working with different operating systems.

Useful links

• Homepage
• Source code can be found on Github
• The documentation on Readthedoc
• The project wiki
• Download page

Frequently asked questions

• Charsets are displayed wrongly
• Size limit for file uploads

Check documentation for full list of frequent questions.

Similar lightweight tools:

• adminer
• xampp
• wamp
• lampp
• sqlbuddy
• phpMiniAdmin
• mysql-workbench MySQL Workbench (Desktop Application)