MySQL

Share This
« Back to Glossary Index
  • Rating:
  • (4674)

MySQL is the world’s most used open source relational database management system that runs as a server providing multi-user access to a number of databases. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (Source WikiPedua)

MySQL (Wikipedia)

MySQL
MySQL logo.svg
Mysql-screenshot.PNG
Screenshot of the default MySQL command-line banner and prompt
Original author(s)MySQL AB
Developer(s)Oracle Corporation
Initial release23 May 1995; 26 years ago (1995-05-23)
Stable release
8.0.26 Edit this on Wikidata / 20 July 2021; 31 days ago (20 July 2021)
Repository Edit this at Wikidata
Written inC, C++
Operating systemLinux, Solaris, macOS, Windows, FreeBSD
Available inEnglish
TypeRDBMS
LicenseGPLv2 or proprietary
Websitewww.mysql.com Edit this on Wikidata

MySQL (/ˌmˌɛsˌkjuːˈɛl/) 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, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language 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.

MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation). In 2010, when Oracle acquired Sun, Widenius forked the open-source MySQL project to create MariaDB.

MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook,Flickr,MediaWiki,Twitter, and YouTube.

About David Rashty

David Rashty, an entrepreneur and one of the early web pioneers, has over twenty years’ experience as a CTO and a CEO. David is the funder and CEO of CreativeMinds which focus on WordPress and Magento products.