Skip to content

PhpMyAdmin

phpMyAdmin is an open-source tool that was built to manage the databases that modern websites have come to rely on. It was written in PHP with some JavaScript and CSS thrown in, and its user interface works in any web browser. It was created with MySQL database administration in mind and will work under any OS and in 68 different languages (although that’s at the time of writing, it may be even more by now!) phpMyAdmin first came out in 1998 and in the two decades since its inception its popularity as a MySQL database manager has gone from strength to strength.

As we have said, phpMyAdmin’s user interface is web-based, which means that you can easily create, delete or edit the databases you need at will, and you can also manage all of their elements from the comfort of your favorite browser. Rows and columns in tables, indexes, fields, statements and queries can all be edited, and you can also control user permissions too, not just on one server but across many at the same time. With phpMyAdmin you can synchronize your databases, which means that you can search through and import text files and keep track of changes across all of them. You can run complicated queries and SQL statements, create and modify functions, and set up events and triggers. phpMyAdmin lets you back up your databases and export data into numerous file types including CSV, SQL, XML, PDF, ODF, DOCX, XLS, and LATEX among others. It also supports foreign keys, mysqli and InnoDB.