1. Home
2. Applications
3. phpMyAdmin Development

AAHA solutions phpMyAdmin Development

About phpMyAdmin

phpMyAdmin is a free web application that provides a convenient GUI for working with the MySQL database management system. It is the most popular MySQL administration tool that is used by millions of users worldwide and has won numerous awards and honors.

Written in PHP, it has all common functions that you may need when developing a MySQL-based application or website. It also gave birth to several similar products, for example phpPgAdmin which provides similar functionality for the PostgreSQL DBMS.

Overview of phpMyAdmin Capabilities

You can use phpMyAdmin for Windows or almost any other operating system ever existed. It can export and import database created and managed by MySQL DBMS, as well as work with some other data formats.

The list of supported formats includes SQL, CVS, CodeGen, CVS for Microsoft Excel, Microsoft Word 2000, JSON, LaTeX, MediaWiki Table, OpenDocument Spreadsheet, OpenDocument Text, PDF, PHP Array, Texy! Text and YAML data types.

General Features with phpMyAdmin

Create and remove users, manage user permissions

Create, alter and drop databases, tables, fields and rows

Administering multiple servers

Make complex SQL queries easier

Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.

Creating complex queries using query-by-example (QBE)

Web interface

Searching globally in a database or a subset of it

The tool is very simple to set up and use. It is usually installed on the same computer with MySQL database, so all commands are executed very quickly and don’t rely on network connectivity.