Tools Provided with MySQL

The MySQL distribution includes the following tools:

• A SQL server. This is the engine that powers MySQL and provides access to your databases.

• Client programs for accessing the server. An interactive program allows you to enter queries directly and view the results, and several administrative and utility programs help you run your site. One utility allows you to control the server. Others let you import or export data, check access permissions, and more.

• A client library for writing your own programs. You can write clients in C because the library is in C, but the library also provides the basis for third-party bindings for other languages.

In addition to the software provided with MySQL itself, MySQL is used by many talented and capable people who like writing software to enhance their productivity and who are willing to make that software available. The result is that you have access to a variety of third-party tools that make MySQL easier to use or that extend its reach into areas such as Web site development.