phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL over the World Wide Web.
This tool can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.
phpMyAdmin can manage a whole MySQL server as well as a single database. To achieve the latter you need a properly set up MySQL user who can read/write only the desired database.
Key Features
- Intuitive web interface.
- Browse through databases and tables.
- Create, copy, rename, alter and drop databases.
- Create, copy, rename, alter and drop tables.
- Perform table maintenance.
- Add, edit and drop fields.
- Execute any SQL-statement, even multiple queries.
- Create, alter and drop indexes.
- Load text files into tables.
- Create and read dumps of tables or databases.
- Export data to SQL, CSV, XML, Word, Excel, PDF, ISO/IEC 26300 (OpenDocument Text and Spreadsheet), LaTeX formats and others.
- Administer multiple servers.
- Manage MySQL users and privileges.
- Check server settings and runtime information with configuration hints.
- Check referential integrity in MyISAM tables.
- Create complex queries using Query-by-example (QBE), automatically connecting required tables.
- Create PDF graphics of the database layout.
- Search globally in a database or a subset of it.
- Transform stored data into any format using a set of predefined functions, such as displaying BLOB-data as image or download-link.
- Active query monitor.
- Manage InnoDB tables and foreign keys.
- Fully internationalized and localized in dozens of languages.
Website: www.phpmyadmin.net
Support: Documentation
Developer: phpMyAdmin Project
License: GNU General Public License v2.0
phpMyAdmin is written in PHP and JavaScript. Learn PHP with our recommended free books and free tutorials. Learn JavaScript with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.