phpMyAdmin is an open-source, web-based MySQL administration tool written in PHP. Use this tag for problems related to using this tool and not for general query problems
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 othersAdministering 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-linkLive 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
Check documentation for full list of frequent questions.
Similar lightweight tools:
- adminer
- xampp
- wamp
- lampp
- sqlbuddy
- phpMiniAdmin
- mysql-workbench MySQL Workbench (Desktop Application)
