Developer(s) Oracle Corporation
Initial release May 23, 1995
Stable release 5.1.45 (March 17, 2010; 5 days ago) [+/−]
Preview release 5.5.2 (February 14, 2010; 36 days ago) [+/−]
Written in C, C++
Operating system Cross-platform
Available in English
Type RDBMS
License GNU General Public License (version 2, with linking exception) or proprietary EULA
Website www.mysql.com
dev.mysql.com
MySQL is a relational database management system (RDBMS)[1] that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"),[2] but is often pronounced /maɪsiːˈkwɛl/ ("Micey Quell") or /maɪˈsiːkwəl/ ("My Sequel").[citation needed] It is named for original developer Michael Widenius's daughter My.[3]
The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Sun Microsystems, a subsidiary of Oracle Corporation.[4]
Members of the MySQL community have created several forks such as Drizzle and MariaDB. Both forks were in progress long before the Oracle acquisition (Drizzle was announced 8 months before the Sun acquisition).
Free-software projects that require a full-featured database management system often use MySQL. Such projects include (for example) WordPress, phpBB, Drupal and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide Web products including Wikipedia, Google and Facebook.
Management and Graphical Frontends
MySQL is primarily an RDBMS and therefore ships with no GUI tools to administer MySQL databases or manage data contained within. Users may use the included command-line tools,[14] or download MySQL Frontends from various parties that have developed desktop software and web applications to manage MySQL databases, build database structure, and work with data records.
[edit]Official
The official MySQL Workbench is a free integrated environment developed by MySQL AB, that enables users to graphically administer MySQL databases and visually design database structure. MySQL Workbench replaces the previous package of software, MySQL GUI Tools. Similar to other third-party packages but still considered the authoritative MySQL frontend, MySQL Workbench lets users manage the following:
Database design & modeling
SQL development — replacing MySQL Query Browser
Database administration — replacing MySQL Administrator
MySQL Workbench is available in two editions, the regular free and open source Community Edition which may be downloaded from the MySQL website, and the proprietary Standard Edition which extends and improves the feature set of the Community Edition.
[edit]Third party
Several other third-party proprietary and free graphical administration applications (or "Frontends") are available that integrate with MySQL and enable users to work with database structure and data visually. Some well-known frontends are:
phpMyAdmin - a free Web-based frontend widely installed by Web hosts worldwide, since it is developed in PHP and only requires the LAMP stack.
HeidiSQL - a full featured free frontend that runs on Windows, and can connect to local or remote MySQL servers to manage databases, tables, column structure, and individual data records. Also supports specialised GUI features for date/time fields and enumerated multiple-value fields[15].
Adminer - a free MySQL frontend written in one PHP script, capable of managing multiple databases, with many CSS skins available.
Navicat - a series of proprietary graphical database management applications, developed for Windows, Macintosh and Linux.
Other available proprietary MySQL frontends include Aqua Data Studio, dbForge Studio for MySQL, Epictetus, Oracle SQL Developer, SchemaBank, SQLyog, SQLPro SQL Client, Toad and Toad Data Modeler.
Initial release May 23, 1995
Stable release 5.1.45 (March 17, 2010; 5 days ago) [+/−]
Preview release 5.5.2 (February 14, 2010; 36 days ago) [+/−]
Written in C, C++
Operating system Cross-platform
Available in English
Type RDBMS
License GNU General Public License (version 2, with linking exception) or proprietary EULA
Website www.mysql.com
dev.mysql.com
MySQL is a relational database management system (RDBMS)[1] that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"),[2] but is often pronounced /maɪsiːˈkwɛl/ ("Micey Quell") or /maɪˈsiːkwəl/ ("My Sequel").[citation needed] It is named for original developer Michael Widenius's daughter My.[3]
The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Sun Microsystems, a subsidiary of Oracle Corporation.[4]
Members of the MySQL community have created several forks such as Drizzle and MariaDB. Both forks were in progress long before the Oracle acquisition (Drizzle was announced 8 months before the Sun acquisition).
Free-software projects that require a full-featured database management system often use MySQL. Such projects include (for example) WordPress, phpBB, Drupal and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide Web products including Wikipedia, Google and Facebook.
Management and Graphical Frontends
MySQL is primarily an RDBMS and therefore ships with no GUI tools to administer MySQL databases or manage data contained within. Users may use the included command-line tools,[14] or download MySQL Frontends from various parties that have developed desktop software and web applications to manage MySQL databases, build database structure, and work with data records.
[edit]Official
The official MySQL Workbench is a free integrated environment developed by MySQL AB, that enables users to graphically administer MySQL databases and visually design database structure. MySQL Workbench replaces the previous package of software, MySQL GUI Tools. Similar to other third-party packages but still considered the authoritative MySQL frontend, MySQL Workbench lets users manage the following:
Database design & modeling
SQL development — replacing MySQL Query Browser
Database administration — replacing MySQL Administrator
MySQL Workbench is available in two editions, the regular free and open source Community Edition which may be downloaded from the MySQL website, and the proprietary Standard Edition which extends and improves the feature set of the Community Edition.
[edit]Third party
Several other third-party proprietary and free graphical administration applications (or "Frontends") are available that integrate with MySQL and enable users to work with database structure and data visually. Some well-known frontends are:
phpMyAdmin - a free Web-based frontend widely installed by Web hosts worldwide, since it is developed in PHP and only requires the LAMP stack.
HeidiSQL - a full featured free frontend that runs on Windows, and can connect to local or remote MySQL servers to manage databases, tables, column structure, and individual data records. Also supports specialised GUI features for date/time fields and enumerated multiple-value fields[15].
Adminer - a free MySQL frontend written in one PHP script, capable of managing multiple databases, with many CSS skins available.
Navicat - a series of proprietary graphical database management applications, developed for Windows, Macintosh and Linux.
Other available proprietary MySQL frontends include Aqua Data Studio, dbForge Studio for MySQL, Epictetus, Oracle SQL Developer, SchemaBank, SQLyog, SQLPro SQL Client, Toad and Toad Data Modeler.
Comments
Post a Comment