{"id":674,"date":"2016-06-04T08:58:11","date_gmt":"2016-06-04T15:58:11","guid":{"rendered":"https:\/\/database.guide\/?p=674"},"modified":"2020-02-14T16:29:34","modified_gmt":"2020-02-14T23:29:34","slug":"what-is-mysql","status":"publish","type":"post","link":"https:\/\/database.guide\/what-is-mysql\/","title":{"rendered":"What is MySQL?"},"content":{"rendered":"

MySQL<\/dfn> is an open source relational database management system (RDBMS<\/a>).\u00a0It\u00a0is the world’s most popular open source RDBMS and is currently\u00a0ranked as\u00a0the second\u00a0most popular RDBMS in the world (behind Oracle Database<\/a>).<\/p>\n

MySQL is available as a free download, however, several paid editions are also available\u00a0which\u00a0offer additional functionality.<\/p>\n

As the name suggests, MySQL is based on SQL<\/a>. The “My” part is named after co-founder\u00a0Michael Widenius’ daughter, My.<\/p>\n

<\/p>\n

Who Uses MySQL?<\/h2>\n

MySQL is used by some of the largest organisations in the world, including Facebook, Google, Twitter, Adobe, Flickr, Alcatel Lucent, Zappos, YouTube, and many more.<\/p>\n

However, it is also used by many\u00a0smaller scale projects such as personal websites or blogs.<\/p>\n

MySQL\u00a0is the default database<\/a>\u00a0for the\u00a0WordPress platform\u00a0– which at the time of writing, is\u00a0said to account for more than\u00a026%<\/a> of all\u00a0sites on the web. Other content management systems and forum software\u00a0that use MySQL include\u00a0TYPO3, MODx, Joomla, phpBB, MyBB, and Drupal.<\/p>\n

Who Owns MySQL?<\/h2>\n

MySQL is currently owned by Oracle Corporation. It was originally owned and sponsored by MySQL AB – a Swedish, single for-profit firm. Sun Microsystems bought\u00a0MySQL AB\u00a0in 2008. Oracle Corporation then bought Sun Microsystems in 2010.<\/p>\n

MySQL Tools<\/h2>\n

MySQL includes a number of\u00a0clients and tools for working with MySQL databases. There are also many other tools that have been written by the open source community specifically for working with MySQL. Here are some of the more popular ones.<\/p>\n

MySQL Workbench<\/h3>\n
\"Screenshot<\/a>
MySQL Workbench is a graphical tool for working with MySQL.<\/figcaption><\/figure>\n

MySQL provides\u00a0MySQL Workbench<\/a>\u00a0as a\u00a0graphical tool for working with MySQL. It\u00a0can be used for performing tasks such as:<\/p>\n