One of typically the most popular tools for MySQL database administration.
is a free software program written in PHP, intended to manage the administration of MySQL over the Web. Because phpMyAdmin
runs in a Web browser, you can access it from just about any computer. phpMyAdmin
has enough functionality which you can probably create and run a Web site without knowing any SQL.
Installation of phpMyAdmin
on a server is simple, assuming you already have PHP and MySQL running. Full instructions are available in the official wiki, but the process is little more than extracting files and running a setup script. phpMyAdmin
has visual interfaces for most MySQL jobs, including creating, browsing, and editing tablesphpMyAdmin
supports an extensive range of operations on MySQL, MariaDB and Drizzle. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed through the user interface, while you still have the ability to directly execute any SQL statement.
comes with an extensive variety of documentation. To ease use to a wide range of people, phpMyAdmin
is being translated into 72 languages and supports both LTR and RTL languages.
Download and install phpMyAdmin
safely and without concerns.
phpMyAdmin highlights and features:
Intuitive web interface
Support for most MySQL characteristics:
browse and drop databases, tables, views, fields and indexes
create, duplicate, drop, rename and alter databases, tables, fields and indexes
maintenance server, databases and tables, with suggestions on server configuration
execute, edit and bookmark any SQL-statement, even batch-queries
manage MySQL users and privileges
manage stored procedures and triggers
Import data from CSV and SQL
Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX and others
Administering multiple servers
Creating PDF graphics of your database layout
Creating complex queries using Query-by-example (QBE)
Searching globally in a database or a subset of it
Transforming stored data into any format by means of a set of predefined functions, like displaying BLOB-data as image or download-link