phpMyAdmin is an application that allows you to manage multiple databases from virtually anywhere. It is written in the PHP server-side programming language and supports MySQL, MariaDB and Drizzle.

An intuitive web-based interface

With an intuitive web-based interface, the application lets database developers to easily manage an entire MySQL server, as well as a single database. It makes it possible to browse, alter, copy, rename, create and drop database, views, indexes, tables and fields. You can execute any type of SQL statement, create dumps of tables and databases, as well as to export and import CSV data.

Features at a glance

With phpMyAdmin you will also be able to manage keys on fields, load text files into tables, create (*) and read dumps of tables, manage MySQL users and privileges. Another attractive feature is the ability to check referential integrity in MyISAM tables. In addition, the program lets users to create PDF graphics of their database layout, search globally in a database or a subset, or manage stored triggers and procedures.

Maintaining a supported database servers, as well as tables and databases has never been easier with the phpMyAdmin application, which also enables database developers to quickly manage MySQL users and privileges. Exporting data to various OpenDocument Spreadsheet and Text, Word, PDF, LATEX, SQL, CSV and XML file formats is yet another powerful functionality of phpMyAdmin.

Complex queries can be created using the QBE (Query-by-Example) method. Besides administering multiple database servers, developers can also create PDF (Portable Document Format) graphics of their database layouts. By using a collection of predefined functions, the phpMyAdmin application can be used to transform stored data into any supported format. We also have to mention the fact that you can globally search in a database or a subset of it.

Bottom line

phpMyAdmin is an essential application for all database administrators and developers. It is translated into 72 languages and actively developed.

Filed under

MySQL administration Database administration Database management MySQL SQL Database Administration