The Enterprise Installer for Windows provides both background information on MySQL and links to the MySQL Web site and documentation. The installer can be used to add any of the MySQL Enterprise components to your Microsoft Windows 2000, Windows XP or Windows Server 2003 computers.

To start the installation process:

Double click on the mysql-enterprise-VERSION-win32.exe installer application, where VERSION is the version number of the release you are installing. For example, mysql-enterprise-5.0.26-win32.exe. There may be a slight pause before the installer shows the first stage of the installation process as the installer extracts some components.

This section does not apply to MySQL Community Server users.

The Enterprise Installer for Linux is available for a number of different platforms. The installer is an executable component that provides a GUI interface (using the X Windows System) to the installation process using the native package management format (for example RPM). Alternatively, you may install the RPMs individually from the command line.

To use the Linux Enterprise Installer:

To start the installer, extract the installation package:

shell> bunzip2 
    mysql-enterprise-VERSION.PLATFORM.x86_64.tar.bz
shell> tar xf mysql-enterprise-VERSION.PLATFORM.x86_64.tar

VERSION is the version number of the MySQL Enterprise release that you are installing; PLATFORM is the name of the supported platform, for example rhel4 for RedHat Enterprise Linux v4.

The installer and packages can be located in the sub directory created when the files were extracted. You should change to this directory and then run the

shell> cd mysql-enterprise-VERSION
shell> ./installer

To the run the installer on the target machine, with the installer display being provided on a different on a different X11 server, set the DISPLAY environment variable:

shell> DISPLAY=remote:0.0 ./installer

You should replace the remote:0.0 with the hostname and display/screen number for the display you are using.

Once started, you will be presented with the main installer window, as shown below. Note that the format of this window may differ depending on the window manager (KDE, Gnome, etc.) that you might have installed.

To install from directly from the RPMs without using the installer, change to the packages directory within the main MySQL Enterprise installer directory and type:

shell> rpm -iv mysql-*.rpm

If you upgrading from a previous version of any of these packages, use:

shell> rpm -Uv mysql-*.rpm

This section does not apply to MySQL Community Server users.

Whether you are running the Enterprise Installer under Windows or Linux, the basic interface and options available to you are the same. Initially, you will be offered three choices:

If you exit the installer at this stage, using the Exit link, no software will have been installed.

2.3.4.3.1. MySQL Enterprise Installation Process

To install MySQL components, choose option 2 (Installation). The main installation screen enables you to select the type of installation.

Four different installation options are available:

1. Server Default — this installs all of the components required for running a MySQL database server, including the core server application, command line utilities, the MySQL client library, and documentation. The MySQL GUI tools and connectors are not installed with this option.

2. Client Default — this installs all of the components required for a client to communicate with a MySQL database server. This includes the MySQL client library, GUI tools, connectors, and documentation.

3. Full — this installs all the available components, including MySQL database server, client library, GUI tools, connectors, and documentation.

4. Custom — this option enables you to select the individual components to be installed. You can choose not only the major groups (for example MySQL database server) but also individual subcomponents (command-line utilities). You will need to select the individual components that you want to install.

   

These options are summarized in the table below.

Component	Server Default	Client Default	Full	Custom
MySQL Server	Yes	No	Yes	Optional
Client Library	Yes	Yes	Yes	Optional
GUI Tools	No	Yes	Yes	Optional
Connectors	No	Yes	Yes	Optional
Documentation	Yes	Yes	Yes	Optional

MySQL Network Service Agent

The MySQL Network Service Agent can be installed by selecting the appropriate option when the installation process for the main components has been completed.

You must have a MySQL Network Monitoring and Advisory Service Network Manager already installed and running on your network to use the Service Agent. You will need the MySQL Agent URL to complete the configuration process.

Once you have selected the type of installation, or selected the individual components to be installed if you have selected the Custom installation type, the installation process will start to copy the files, applications and other components to your machine.

The installation process will take some time, with the exact period depending on the features and options that you have selected to install.

Once the process has completed, you will need to click Next to complete the post-installation process. You can choose to automatically execute the MySQL Server Configuration Wizard (which provides an interface for configuring the parameters of your MySQL Server installation) and the MySQL Network Monitoring and Advisory Service Installer.

To complete the installation sequence and execute the optional post-installation processes, click Finish.

The MySQL Server Configuration Wizard is normally started as part of the installation process. You should only need to run the MySQL Server Configuration Wizard again when you need to change the configuration parameters of your server.

--defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"

shell>
DISPLAY=remote:0.0 mysqlsetup

If the MySQL Server Configuration Wizard detects an existing configuration file, you have the option of either reconfiguring your existing server, or removing the server instance by deleting the configuration file and stopping and removing the MySQL service.

To reconfigure an existing server, choose the Re-configure Instance option and click the Next button. Any existing configuration file is not overwritten, but renamed (within the same directory) using a timestamp (Windows) or sequential number (Linux). To remove the existing server instance, choose the Remove Instance option and click the Next button.

If you choose the Remove Instance option, you advance to a confirmation window. Click the Execute button. The MySQL Server Configuration Wizard stops and removes the MySQL service, and then deletes the configuration file. The server installation and its data folder are not removed.

If you choose the Re-configure Instance option, you advance to the Configuration Type dialog where you can choose the type of installation that you wish to configure.

When you start the MySQL Server Configuration Wizard for a new MySQL installation, or choose the Re-configure Instance option for an existing installation, you advance to the Configuration Type dialog.

There are two configuration types available: Detailed Configuration and Standard Configuration. The Standard Configuration option is intended for new users who want to get started with MySQL quickly without having to make many decisions about server configuration. The Detailed Configuration option is intended for advanced users who want more fine-grained control over server configuration.

If you are new to MySQL and need a server configured as a single-user developer machine, the Standard Configuration should suit your needs. Choosing the Standard Configuration option causes the MySQL Configuration Wizard to set all configuration options automatically with the exception of Service Options and Security Options.

The Standard Configuration sets options that may be incompatible with systems where there are existing MySQL installations. If you have an existing MySQL installation on your system in addition to the installation you wish to configure, the Detailed Configuration option is recommended.

To complete the Standard Configuration, please refer to the sections on Service Options and Security Options in Section 2.3.6.10, “The Service Options Dialog”, and Section 2.3.6.11, “The Security Options Dialog”, respectively.

There are three different server types available to choose from. The server type that you choose affects the decisions that the MySQL Server Configuration Wizard makes with regard to memory, disk, and processor usage.

The Database Usage dialog allows you to indicate the storage engines that you expect to use when creating MySQL tables. The option you choose determines whether the InnoDB storage engine is available and what percentage of the server resources are available to InnoDB.

Some users may want to locate the InnoDB tablespace files in a different location than the MySQL server data directory. Placing the tablespace files in a separate location can be desirable if your system has a higher capacity or higher performance storage device available, such as a RAID storage system.

To change the default location for the InnoDB tablespace files, choose a new drive from the drop-down list of drive letters and choose a new path from the drop-down list of paths. To create a custom path, click the ... button.

If you are modifying the configuration of an existing server, you must click the Modify button before you change the path. In this situation you must move the existing tablespace files to the new location manually before starting the server.

To prevent the server from running out of resources, it is important to limit the number of concurrent connections to the MySQL server that can be established. The Concurrent Connections dialog allows you to choose the expected usage of your server, and sets the limit for concurrent connections accordingly. It is also possible to set the concurrent connection limit manually.

Use the Networking Options dialog to enable or disable TCP/IP networking and to configure the port number that is used to connect to the MySQL server.

TCP/IP networking is enabled by default. To disable TCP/IP networking, uncheck the box next to the Enable TCP/IP Networking option.

Port 3306 is used by default. To change the port used to access MySQL, choose a new port number from the drop-down box or type a new port number directly into the drop-down box. If the port number you choose is in use, you are prompted to confirm your choice of port number.

Set the Server SQL Mode to either enable or disable strict mode. Enabling strict mode (default) makes MySQL behave more like other database management systems. If you run applications that rely on MySQL's old “forgiving” behavior, make sure to either adapt those applications or to disable strict mode. For more information about strict mode, see Section 5.2.6, “SQL Modes”.

The MySQL server supports multiple character sets and it is possible to set a default server character set that is applied to all tables, columns, and databases unless overridden. Use the Character Set dialog to change the default character set of the MySQL server.

This section does not apply to MySQL Community Server users.

On Windows NT-based platforms, the MySQL server can be installed as a Windows service. When installed this way, the MySQL server can be started automatically during system startup, and even restarted automatically by Windows in the event of a service failure.

The MySQL Server Configuration Wizard installs the MySQL server as a service by default, using the service name MySQL. If you do not wish to install the service, uncheck the box next to the Install As Windows Service option. You can change the service name by picking a new service name from the drop-down box provided or by entering a new service name into the drop-down box.

To install the MySQL server as a service but not have it started automatically at startup, uncheck the box next to the Launch the MySQL Server Automatically option.

It is strongly recommended that you set a root password for your MySQL server, and the MySQL Server Configuration Wizard requires by default that you do so. If you do not wish to set a root password, uncheck the box next to the Modify Security Settings option.

To set the root password, enter the desired password into both the New root password and Confirm boxes. If you are reconfiguring an existing server, you need to enter the existing root password into the Current root password box.

To prevent root logins from across the network, check the box next to the Root may only connect from localhost option. This increases the security of your root account.

To create an anonymous user account, check the box next to the Create An Anonymous Account option. Creating an anonymous account can decrease server security and cause login and permission difficulties. For this reason, it is not recommended.

The final dialog in the MySQL Server Configuration Wizard is the Confirmation Dialog. To start the configuration process, click the Execute button. To return to a previous dialog, click the Back button. To exit the MySQL Server Configuration Wizard without configuring the server, click the Cancel button.

After you click the Execute button, the MySQL Server Configuration Wizard performs a series of tasks and displays the progress onscreen as the tasks are performed.

The MySQL Server Configuration Wizard first determines configuration file options based on your choices using a template prepared by MySQL AB developers and engineers. This template is named my-template.ini and is located in your server installation directory.

The MySQL Configuration Wizard then writes these options to the corresponding configuration file.

If you chose to create a service for the MySQL server, the MySQL Server Configuration Wizard creates and starts the service. If you are reconfiguring an existing service, the MySQL Server Configuration Wizard restarts the service to apply your configuration changes.

If you chose to set a root password, the MySQL Configuration Wizard connects to the server, sets your new root password, and applies any other security settings you may have selected.

After the MySQL Server Configuration Wizard has completed its tasks, it displays a summary. Click the Finish button to exit the MySQL Server Configuration Wizard.

To uninstall MySQL Enterprise on Windows you should use the Add or Remove Programs utility located within the Control Panel.

Packages within MySQL Enterprise must be removed individually. You may also use this option to remove packages that you no longer want or use.

Any data you created while MySQL Enterprise was installed will not be removed. You will need to separately delete this information.

To uninstall MySQL Enterprise on a Linux operating system that uses the RPM package format, you must remove each of the packages that were installed by the MySQL Enterprise Installer individually.

To do this, first obtain a list of the installed packages:

shell> rpm -q -a|grep -i mysql
mysql-docs-en-5.0.26-1
MySQL-server-standard-5.0.26-0.rhel4
mysql-connector-j-5.0.3-1
MySQL-devel-standard-5.0.26-0.rhel4
mysql-query-browser-5.0r4-1rhel4
mysql-connector-odbc-3.51.12-1
MySQL-client-standard-5.0.26-0.rhel4
mysql-administrator-5.0r4-1rhel4
mysql-gui-tools-5.0r4-1rhel4
mysql-setup-wizard-1.0-1
mysql-connector-net-1.0.7-1

You can remove these packages individually, or all together automatically, like this:

shell> rpm -q -a|grep -i mysql|xargs rpm --erase

This section does not apply to MySQL Enterprise Server users.

The first decision to make is whether you want to use a production (stable) release or a development release. In the MySQL development process, multiple release series co-exist, each at a different stage of maturity:

We do not believe in a complete code freeze because this prevents us from making bugfixes and other fixes that must be done. By “somewhat frozen” we mean that we may add small things that should not affect anything that currently works in a production release. Naturally, relevant bugfixes from an earlier series propagate to later series.

Normally, if you are beginning to use MySQL for the first time or trying to port it to some system for which there is no binary distribution, we recommend going with the production release series. Currently, this is MySQL 5.0. All MySQL releases, even those from development series, are checked with the MySQL benchmarks and an extensive test suite before being issued.

If you are running an older system and want to upgrade, but do not want to take the chance of having a non-seamless upgrade, you should upgrade to the latest version in the same release series you are using (where only the last part of the version number is newer than yours). We have tried to fix only fatal bugs and make only small, relatively “safe” changes to that version.

If you want to use new features not present in the production release series, you can use a version from a development series. Note that development releases are not as stable as production releases.

If you want to use the very latest sources containing all current patches and bugfixes, you can use one of our BitKeeper repositories. These are not “releases” as such, but are available as previews of the code on which future releases are to be based.

The MySQL naming scheme uses release names that consist of three numbers and a suffix; for example, mysql-5.0.12-beta. The numbers within the release name are interpreted as follows:

For each minor update, the last number in the version string is incremented. When there are major new features or minor incompatibilities with previous versions, the second number in the version string is incremented. When the file format changes, the first number is increased.

Release names also include a suffix to indicates the stability level of the release. Releases within a series progress through a set of suffixes to indicate how the stability level improves. The possible suffixes are:

MySQL uses a naming scheme that is slightly different from most other products. In general, it is usually safe to use any version that has been out for a couple of weeks without being replaced by a new version within the same release series.

All releases of MySQL are run through our standard tests and benchmarks to ensure that they are relatively safe to use. Because the standard tests are extended over time to check for all previously found bugs, the test suite keeps getting better.

All releases have been tested at least with these tools:

We also test the newest MySQL version in our internal production environment, on at least one machine. We have more than 100GB of data to work with.

This section does not apply to MySQL Enterprise Server users.

After choosing which version of MySQL to install, you should decide whether to use a binary distribution or a source distribution. In most cases, you should probably use a binary distribution, if one exists for your platform. Binary distributions are available in native format for many platforms, such as RPM files for Linux or PKG package installers for Mac OS X or Solaris. Distributions also are available as Zip archives or compressed tar files.

Reasons to choose a binary distribution include the following:

Under some circumstances, you may be better off installing MySQL from a source distribution:

MySQL is evolving quite rapidly and we want to share new developments with other MySQL users. We try to produce a new release whenever we have new and useful features that others also seem to have a need for.

We also try to help users who request features that are easy to implement. We take note of what our licensed users want, and we especially take note of what our support customers want and try to help them in this regard.

No one is required to download a new release. The News section helps you determine whether the new release has something you really want. See Appendix F, MySQL Change History.

We use the following policy when updating MySQL:

This section does not apply to MySQL Enterprise Server users.

We put considerable time and effort into making our releases bug-free. Our policy is never to release a version of MySQL intended for production use that has any known fatal, repeatable bugs.

We have documented all open problems, bugs, and issues that are dependent on design decisions. See Section B.8, “Known Issues in MySQL”.

Our aim is to fix everything that is fixable without making a stable MySQL version less stable. In certain cases, this means we can fix an issue in the development versions, but not in the stable (production) version. Naturally, we document such issues so that users are aware of them.

Here is a description of our build process:

This section does not apply to MySQL Enterprise Server users.

As a service of MySQL AB, we provide a set of binary distributions of MySQL that are compiled on systems at our site or on systems where supporters of MySQL kindly have given us access to their machines.

In addition to the binaries provided in platform-specific package formats, we offer binary distributions for a number of platforms in the form of compressed tar files (.tar.gz files). See Section 2.4.7, “Standard MySQL Installation Using a Binary Distribution”.

The RPM distributions for MySQL 5.0 releases that we make available through our Web site are generated by MySQL AB.

For Windows distributions, see Section 2.4.8, “Installing MySQL on Windows”.

These distributions are generated using the script Build-tools/Do-compile, which compiles the source code and creates the binary tar.gz archive using scripts/make_binary_distribution.

These binaries are configured and built with the following compilers and options. This information can also be obtained by looking at the variables COMP_ENV_INFO and CONFIGURE_LINE inside the script bin/mysqlbug of every binary tar file distribution.

Anyone who has more optimal options for any of the following configure commands can mail them to the MySQL internals mailing list. See Section 1.7.1, “MySQL Mailing Lists”.

If you want to compile a debug version of MySQL, you should add --with-debug or --with-debug=full to the following configure commands and remove any -fomit-frame-pointer options.

The following binaries are built on MySQL AB development systems: