PhpMyAdmin

Last updated
phpMyAdmin
Developer(s) The phpMyAdmin Project
Initial releaseSeptember 9, 1998;25 years ago (1998-09-09)
Stable release
5.2.1 [1]   OOjs UI icon edit-ltr-progressive.svg / 2023-02-08; 11 months ago [±]
Preview release
5.2.0-rc1 [2] / January 22, 2022;2 years ago (2022-01-22)
Repository https://github.com/phpmyadmin/phpmyadmin
Written in PHP, JavaScript
Operating system Cross-platform
Available in95 [3] languages
Type Database management
License GNU General Public License 2
Website www.phpmyadmin.net

phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services. [4]

Contents

History

Tobias Ratschiller, then an IT consultant and later founder of the software company Maguma, started to work on a PHP-based web front-end to MySQL in 1998, inspired by MySQL-Webadmin. He gave up the project (and phpAdsNew, of which he was also the original author) in 2000 because of lack of time. [5]

By that time, phpMyAdmin had already become one of the most popular PHP applications and MySQL administration tools, with a large community of users and contributors. In order to coordinate the growing number of patches, a group of three developers (Olivier Müller, Marc Delisle and Loïc Chapeaux) [6] registered The phpMyAdmin Project at SourceForge and took over the development in 2001. [7]

In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network. [8] At the same time, the releases began [9] to be PGP-signed. Afterwards, issue tracking moved to GitHub [10] and the mailing lists migrated. [11] Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.

Features

Features provided by the program include: [12]

  1. Web interface
  2. MySQL and MariaDB database management
  3. Import data from CSV, JSON and SQL
  4. Export data to various formats: CSV, SQL, XML, JSON, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX, SQL, and others
  5. Administering multiple servers
  6. Creating PDF graphics of the database layout
  7. Creating complex queries using query-by-example (QBE)
  8. Searching globally in a database or a subset of it
  9. Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
  10. Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.
  11. Network traffic to the SQL server
  12. Working with different operating systems like Windows*, Linux*, OS/2, Free BSD* Unix* (such as Sun* Solaris*, AIX) and others.
  13. Make complex SQL queries easier.

Implementation

phpMyAdmin could be used to develop administrative system for letter filling, especially in bureaucracy. [13]

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source object relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

<span class="mw-page-title-main">Tiki Wiki CMS Groupware</span> Content management software

Tiki Wiki CMS Groupware or simply Tiki, originally known as TikiWiki, is a free and open source Wiki-based content management system and online office suite written primarily in PHP and distributed under the GNU Lesser General Public License (LGPL-2.1-only) license. In addition to enabling websites and portals on the internet and on intranets and extranets, Tiki contains a number of collaboration features allowing it to operate as a Geospatial Content Management System (GeoCMS) and Groupware web application.

<span class="mw-page-title-main">Kexi</span> KDE visual database applications creator

Kexi is a visual database applications creator tool by KDE, designed to fill the gap between spreadsheets and database solutions requiring more sophisticated development. Kexi can be used for designing and implementing databases, data inserting and processing, and performing queries. It is developed within the Calligra project but is released separately.

<span class="mw-page-title-main">Mantis Bug Tracker</span> Bug tracking system

Mantis Bug Tracker is a free and open source, web-based bug tracking system. The most common use of MantisBT is to track software defects. However, MantisBT is often configured by users to serve as a more generic issue tracking system and project management tool.

<span class="mw-page-title-main">XAMPP</span> Free and open-source cross-platform web server solution stack package

XAMPP is a free and open-source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages. Since most actual web server deployments use the same components as XAMPP, it makes transitioning from a local test server to a live server possible.

SQLyog is a GUI tool for the RDBMS MySQL. It is developed by Webyog, Inc., based in Bangalore, India, and Santa Clara, California. SQLyog is being used by more than 30,000 customers worldwide and has been downloaded more than 2,000,000 times.

mysqlBind/unxsBind is a DNS management software system. It supports Internet Systems Consortium BIND Domain Name System (DNS) and is distributed as open source software under the GNU General Public License.

<span class="mw-page-title-main">Apache CouchDB</span> Document-oriented NoSQL database

Apache CouchDB is an open-source document-oriented NoSQL database, implemented in Erlang.

EGroupware is free open-source groupware software intended for businesses from small to enterprises. Its primary functions allow users to manage contacts, appointments, projects and to-do lists. The project releases its software under the terms of GNU General Public License (GPL).

The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.

Web2py is an open-source web application framework written in the Python programming language. Web2py allows web developers to program dynamic web content using Python. Web2py is designed to help reduce tedious web development tasks, such as developing web forms from scratch, although a web developer may build a form from scratch if required.

The RISE Editor is a free information modeling tool for information system development based on model driven development. Functionality includes automatic interface composition, database generation and updates, data insertion, programming interface publishing and web service generation. The modeling takes place in entity relationship diagrams (ERD). The layout for these diagrams can be changed to relational database or unified modeling language (UML) with the functionality staying the same.

CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by CUBRID Corp. for OLTP. The name CUBRID is a combination of the two words cube and bridge, cube standing for a space for data and bridge standing for data bridge.

Plastic SCM is a cross-platform commercial distributed version control tool developed by Códice Software for Microsoft Windows, Mac OS X, Linux, and other operating systems. It includes a command-line tool, native GUIs, diff and merge tool and integration with a number of IDEs. It is a full version control stack not based on Git.

phpLiteAdmin

phpLiteAdmin is an open-source tool written in PHP intended to handle the administration of SQLite over the World Wide Web. Its feature set, interface, and overall user experience is comparable to that of phpMyAdmin for MySQL. In the same way that SQLite is a flat file database, phpLiteAdmin is distributed in the form of a single PHP file. Its ease of installation, portability, and small size go hand in hand with SQLite.

<span class="mw-page-title-main">Apache Drill</span> Open-source software framework

Apache Drill is an open-source software framework that supports data-intensive distributed applications for interactive analysis of large-scale datasets. Built chiefly by contributions from developers from MapR, Drill is inspired by Google's Dremel system. Drill is an Apache top-level project. Tom Shiran is the founder of the Apache Drill Project. It was designated an Apache Software Foundation top-level project in December 2016.

The following outline is provided as an overview of and topical guide to MySQL:

<span class="mw-page-title-main">DBeaver</span> Multi-platform database administration software

DBeaver is a SQL client software application and a database administration tool. For relational databases it uses the JDBC application programming interface (API) to interact with databases via a JDBC driver. For other databases (NoSQL) it uses proprietary database drivers. It provides an editor that supports code completion and syntax highlighting. It provides a plug-in architecture that allows users to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

References

  1. ↑ "phpMyAdmin 5.2.1". 8 February 2023. Retrieved 8 February 2023.
  2. ↑ "phpMyAdmin 5.2.0-rc1". phpMyAdmin. Retrieved 2022-01-22.
  3. ↑ "Translations". phpMyAdmin. Retrieved 17 October 2023.
  4. ↑ "phpMyAdmin Review". PCWorld. 2011-04-20. Retrieved 2017-10-27.
  5. ↑ "phpMyAdmin - About". phpMyAdmin. Retrieved 2013-03-03.
  6. ↑ widftro oppne thesis not isdrhopts colour this baground bsreop bus tayp collkal id not the round fonfgtdi mxcbj@gsgvd bvj fdrehbgh for this echo //php sep20222- 14526 Micral, Achille (12 September 2013). "phpMyAdmin, 15 ans, toujours amoureux" [phpMyAdmin, 15 years old, still in love]. Romgame Fr. (in French). Archived from the original on 15 September 2013. Retrieved 12 May 2019. Plus tard Olivier Müller, Marc Delisle et Loïc Chapeaux on déposé en 2001 phpMyAdmin tel que nous le connaissons sur SourceForge, et son développement ne s'est dès lors jamais arrété.
  7. ↑ Delisle, Marc (2010–2023). Mastering phpMyAdmin 3.3.x for Effective MySQL Management. Packt Publishing. p. 47,455. ISBN   978-1849513548.
  8. ↑ "phpMyAdmin website and downloads moved". phpMyAdmin. 2 July 2015. Retrieved 21 June 2019.
  9. ↑ "Installation — phpMyAdmin 5.2.0-dev documentation". docs.phpmyadmin.net. Retrieved 2021-03-19.
  10. ↑ "phpMyAdmin moves issue tracking to GitHub". phpMyAdmin. 20 July 2015. Retrieved 21 June 2019.
  11. ↑ "phpMyAdmin mailing lists have been moved". phpMyAdmin. 25 July 2015. Retrieved 21 June 2019.
  12. ↑ "phpMyAdmin". phpMyAdmin. Archived from the original on 2013-02-16. Retrieved 2013-03-03.
  13. ↑ Standsyah, R.E.; Restu N.S., I.S. (2017). Pradana, M.S. (ed.). "IMPLEMENTASI PHPMYADMIN PADA RANCANGAN SISTEM PENGADMINISTRASIAN" [IMPLEMENTATION OF PHPMYADMIN IN ADMINISTRATIVE SYSTEM DESIGN](PDF). Unisda Journal of Mathematics and Computer (in Indonesian). 3 (2): 39−44. eISSN   2579-907X . Retrieved 17 October 2023.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.