phpMyAdmin is a web-based administration interface for MySQL and MariaDB database servers. It allows users to inspect and modify databases, execute SQL statements and manage access without relying on a separate desktop client.
The software handles routine database administration, including modifying tables, indexes and records, importing data and exporting databases for backup or migration. Administrators can inspect server configuration and status, while developers can use its query tools to investigate application data.
phpMyAdmin can administer an entire database server or work with an individual database. Access can be restricted through appropriately configured database accounts, allowing users to perform their tasks without receiving unnecessary server-wide privileges.
This is free and open source software.
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:
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 |
| 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 |
| MySQLTuner | Analyse MySQL performance and suggest configuration changes |
| 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 |
| MyDumper | Parallel utilities for fast MySQL database backups and restores |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| Skeema | Manage MySQL and MariaDB schema changes |
| vi-sql | Terminal SQL client for browsing, querying and editing databases |
| MySQL Shell | Advanced MySQL console for scripting and database administration |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.