phpMyAdmin

phpMyAdmin is a web tool for administering MySQL and MariaDB databases. It is written in PHP and runs in a browser.

phpMyAdmin lets you browse, create and alter databases, tables, columns and indexes through a web interface. You can run SQL statements directly, bookmark frequently used queries and run batches of statements together. It also manages MySQL user accounts and privileges, and it supports stored procedures, triggers and schema diagrams. Data can be imported from CSV and SQL files and exported to formats including CSV, SQL and XML. The interface has been translated into many languages.

• Manage databases, tables and indexes
• Run and bookmark SQL statements
• Import and export CSV, SQL and XML
• Manage MySQL users and privileges
• Schema visualisation and query by example

Web developers and hosting admins who manage MySQL or MariaDB. It suits people who want a browser-based admin panel for everyday database tasks.

phpMyAdmin is free software under the GPL and is commonly installed by hosting providers. Security patches should be applied promptly, because a web admin panel is an attractive target. Restrict access to it, use strong passwords and consider limiting it to trusted networks. Multi-server setups are supported for administrators who manage several database servers.