About
phpMyAdmin is a free software tool written in PHP, designed for administering MySQL and MariaDB over the web. It supports a wide range of operations (managing databases, tables, columns, relations, indexes, users, and more) through a user-friendly interface, while also allowing the execution of SQL commands directly.
Comprehensive documentation is available, and users can contribute ideas and tutorials on our wiki. For support, various channels are accessible.
phpMyAdmin is translated into 96 languages, supporting both LTR and RTL languages.
The project is mature, with a stable and flexible codebase. Learn more about its history and the awards it has earned.
phpMyAdmin is a member of the Software Freedom Conservancy, a non-profit promoting Free and Open Source Software.
Features
- Intuitive web interface for easy management and navigation
- Comprehensive MySQL support:
- Browse, drop, and manage databases, tables, views, fields, and indexes
- Create, copy, drop, rename, and alter databases, tables, fields, and indexes
- Server maintenance with configuration suggestions for optimization
- Execute, edit, and bookmark SQL statements, including batch queries
- Manage MySQL user accounts and privileges with ease
- Support for stored procedures and triggers management
- Data import/export in various formats:
- Import from CSV and SQL
- Export to CSV, SQL, XML, PDF, and others like OpenDocument, Word, LaTeX, and more
- Multi-server administration for centralized control over multiple MySQL servers
- Database schema visualization with graphical representations in various formats
- Query-by-example (QBE) to easily create complex queries
- Global database search across tables, columns, or entire databases
- Custom data transformations like displaying BLOB data as images or download links
- And much more...
