MySQL Components

Let's take a moment to look at where MySQL will reside on your system. If you do not yet have MySQL installed, refer to Appendix A, "Installing MySQL."

Linux/UNIX Systems

The location of MySQL programs, libraries, and other files depends on the installation prefix used when MySQL was installed. Typically, the prefix is either /usr/MySQL or /usr/local/MySQL.

In the location used on your system, you will find the following subdirectories:

  • binContains the MySQL executables, including the database server and all the client programs

  • libContains the development libraries used to communicate with a MySQL database from your own programs

  • includeContains the header files required to use MySQL APIs

  • dataThe MySQL data directory, containing the actual database files

  • support_filesA number of sample configuration files

The MySQL configuration file is named my.cnf. The file /etc/my.cnf contains global settings, but you can also create a file named my.cnf in the data directory that applies only to that MySQL server; it is possible to have multiple MySQL servers on one machine.


If you used a packaged installation method such as RPM, the system programs might have been installed to common locations alongside other applications. In this case, the data directory is /var/lib/MySQL.


Make sure that the MySQL bin directory is in your system path so you can avoid having to enter the full path to the client programs when you want to run them. Refer to your operating system documentation for details on how to set this up.

Windows Systems

The default install location is C:\Program Files\MySQL. The system is installed in a subfolder that is named using the MySQL minor version number. For example, MySQL 5.0.18 is installed to C:\Program Files\MySQL\MySQL Server 5.0.

In the version-specific install location, you will find the following subdirectories:

  • binThe MySQL server and client program executables

  • dataThe MySQL data directory, containing the actual database files

In the installation directory, you will also find a number of sample configuration files. The current configuration is found in my.ini located in this folder.

MySQL is installed as a Windows service. To start and stop the database server, go to Control Panel, Administrativ Tools, and select Services. A program group in the Start menu contains a shortcut to the MySQL monitor program and the configuration wizard.

Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors: Chris Newman

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: