* HeidiSQL – a full featured free front end that runs on Windows, and can connect to local or remote MySQL servers to manage databases, tables, column structure, and individual data records.

Like Access, it can be used as a front-end for various database systems, including Access databases ( JET ), ODBC data sources, and MySQL or PostgreSQL.

* OpenOffice. org – OpenOffice. org Base can manage MySQL databases if the entire suite is installed.

* Multiple storage engines, allowing one to choose the one that is most effective for each table in the application ( in MySQL 5. 0, storage engines must be compiled in ; in MySQL 5. 1, storage engines can be dynamically loaded at run time ):

MySQL can be built and installed manually from source code, but this can be tedious so it is more commonly installed from a binary package unless special customizations are required.

On most Linux distributions the package management system can download and install MySQL with minimal effort, though further configuration is often required to adjust security and optimization settings.

In the medium range, MySQL can be scaled by deploying it on more powerful hardware, such as a multi-processor server with gigabytes of memory.

There are however limits to how far performance can scale on a single server, so on larger scales, multi-server MySQL deployments are required to provide improved performance and reliability.

* Virtual Machine Image-cloud users can upload a machine image of their own with MySQL installed, or use a ready-made machine image with an optimized installation of MySQL on it, such as the one provided by Amazon EC2.

It supports security, communications, and web-based applications which can be executed inside the optional IBM WebSphere Application Server or as PHP / MySQL applications inside a native port of the Apache web server.

The feature-limited version can be used widely like MySQL, Eucalyptus and Fedora.

In 2009, it was announced that DB2 can be an engine in MySQL.

However, via plug-ins, PmWiki can already use MySQL or SQLite databases for data storage.

With Gambas, developers can also use databases such as MySQL or PostgreSQL, build KDE ( Qt ) and GNOME GTK + applications with DCOP, translate Visual Basic programs to Gambas and run them under Linux, build network solutions, and create CGI web applications.

By interfacing with MySQL technology, builders can script persistence of object inventories, states, and variables.

It still uses Perl, but runs off a MySQL database, and can be served using any Perl aware webserver, such as Apache.

Oracle and MySQL, for example, can store table data directly on raw block devices.

Free software ER diagramming tools that can interpret and generate ER models and SQL and do database analysis are MySQL Workbench ( formerly DBDesigner ), and Open ModelSphere ( open-source ).

It can use MySQL, ODBC, and Microsoft SQL Server as its DBMS.

For example: SQL Server runs only on Microsoft Windows operating-systems, while Oracle and MySQL can run on Solaris, Linux and other UNIX-based operating-systems as well as on Windows.

It can be used on any web server that has PHP and MySQL installed.

MySQL ( " My S-Q-L ", officially, but also called " My Sequel ") is the world's most used open source relational database management system ( RDBMS ) as of 2008 that runs as a server providing multi-user access to a number of databases.

MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google ( though not for searches ), Facebook, Twitter, Flickr, Nokia. com, and YouTube.

Third-parties have also developed tools to manage a MySQL server, some listed below.

A port of MySQL to OpenVMS also exists.

The HTSQL-URL-based query method also ships with a MySQL adapter, allowing direct interaction between a MySQL database and any web client via structured URLs.

The intent also being to maintain high fidelity with MySQL, ensuring a " drop-in " replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.

MySQL v4. 0. 16 and PHP v4. 3. 7 are also included.

MySQL v4. 0. 16 and PHP v4. 3. 7 are also included.

Berry was inspired to start the project while working for a small ISP while also still in high school, learning PHP and MySQL.

This new software was also written in PHP with a MySQL backend, and kept the basic interface of the phase II software, but was meant to be more scalable.

Together with some additional services, MySQL also provide this as a subscription-based product called MySQL Enterprise, which is also resold by other companies such as Dell, HP, and Novell.

In addition to these magazines, he has also written a number of books, including " The Art of Community ", " Linux Desktop Hacks ", " PHP and MySQL Web Applications: Building Eight Dynamic Web Sites " and he also co-wrote " The Official Ubuntu Book " ( ISBN 0-13-243594-2 ) with Benjamin Mako Hill, Corey Burger, and Jonathan Jesse.

Other programs may also be included in a package, such as phpMyAdmin which provides a graphical user interface for the MySQL database manager, or the alternative scripting languages Python or Perl.

There also exists several third party plug-ins to authenticate against LDAP or SQL databases such as SQLite and MySQL.

MaxDB is an ANSI SQL-92 ( entry level ) compliant relational database management system ( RDBMS ) from SAP AG, which was delivered also by MySQL AB from 2003 to 2007.

Starting with MySQL 5. 1, it is also possible to replicate asynchronously between clusters ; this is sometimes referred to as " MySQL Cluster Replication " or " geographical replication ".

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.

InnoDB used to be a partner-developed storage engine, but with recent acquisitions, Oracle now owns both MySQL core and InnoDB.

After the acquisition, an Oracle press release mentioned that the contracts that make the company's software available to MySQL AB would be due for renewal ( and presumably renegotiation ) some time in 2006.

An exception is when the forked software is designed to be a drop-in replacement of the original project, e. g. MariaDB for MySQL or LibreOffice for OpenOffice. org.

On 16 January 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for approximately $ 1 billion.

MySQL AB representatives are commonly cited as champions of what they claim to be a " second generation " of open source companies.

What generally distinguishes this " second generation " of companies, such as MySQL AB and Trolltech, from earlier " open source " business models is dual licensing — while the software may be made available under the provisions of some open source license, the software is, in fact, owned by the commercial companies who seek to derive revenues from selling traditional software licenses.

As an example, MySQL AB makes MySQL available under the GPL at no charge, but sells it under other more traditional licenses to clients who do not find the GPL to be ideal for their purposes, such as inclusion of MySQL AB technology in a closed source product.