Mysql 5.0 22 win32 zip download

Version: '5. Upgrading the MySQL server requires a large number of steps if you do make a mistake repeat all steps from the beginning.

Apart from security updates real reason for making this change is because itcontains a number of bug fixes. From The Uniform Server Wiki. Navigation menu Personal tools Log in. Namespaces Page Discussion. Views Read View source View history. Navigation Main page Recent changes Random page Help. This page was last edited on 3 August , at For each release, the last number in the version is one more than the previous release within the same series.

Binary distributions for some platforms are made by us for major releases. Other people may make binary distributions for other systems, but probably less frequently. We make fixes available as soon as we have identified and corrected small or noncritical but annoying bugs. The fixes are available in source form immediately from our public Bazaar repositories, and are included in the next release. If by any chance a security vulnerability or critical bug is found in a release, our policy is to fix it in a new release as soon as possible.

We would like other companies to do this, too! In addition to binaries provided in platform-specific package formats, we offer binary distributions for a number of platforms in the form of compressed tar files. For Windows distributions, see Section 2. You can also find information there about becoming a MySQL mirror site and how to report a bad or out-of-date mirror.

After you have downloaded the MySQL package that suits your needs and before you attempt to install it, you should make sure that it is intact and has not been tampered with. There are three means of integrity checking:. If you notice that the MD5 checksum or GPG signatures do not match, first try to download the respective package one more time, perhaps from another mirror site.

Do not report downloading problems using the bug-reporting system. You should verify that the resulting checksum the string of hexadecimal digits matches the one displayed on the download page immediately below the respective package. Make sure to verify the checksum of the archive file for example, the. Note that not all operating systems support the md5sum command. On some, it is simply called md5 , and others do not ship it at all. Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures.

This is more reliable than using MD5 checksums, but requires more work. Most Linux distributions ship with GnuPG installed by default. The key that you want to obtain is named build mysql. Alternatively, you can cut and paste the key directly from the following text:. To import the build key into your personal public GPG keyring, use gpg --import. You can also download the key from the public keyserver using the public key id, E1F5 :. If you want to import the key into your RPM configuration to validate RPM install packages, you should be able to import the key directly:.

If you experience problems, try exporting the key from gpg and importing:. Alternatively, rpm also supports loading the key directly from a URL, and you cas use this manual page:. After you have downloaded and imported the public build key, download your desired MySQL package and the corresponding signature, which also is available from the download page. The signature file has the same name as the distribution file with an.

Make sure that both files are stored in the same directory and then run the following command to verify the signature for the distribution file:. The Good signature message indicates that everything is all right.

You can ignore any insecure memory warning you might obtain. For RPM packages, there is no separate signature. You can verify a package by running the following command:. If you are using RPM 4. RPM 4. Rather, it maintains its own keyring because it is a system-wide application and a user's GPG public keyring is a user-specific file.

Then use rpm --import to import the key. This section describes the default layout of the directories created by installing binary or source distributions provided by Oracle Corporation. A distribution provided by another vendor might use a layout different from those shown here. For MySQL 5. However, the layout of the subdirectories remains the same. The installation directory has the following subdirectories:.

Installations created from our Linux RPM distributions result in files under the following system directories:.

A source distribution is installed after you configure and compile it. Within its installation directory, the layout of a source installation differs from that of a binary installation in the following ways:. The mysqld server is installed in the libexec directory rather than in the bin directory. The data directory is var rather than data. In some cases, the compiler used to build MySQL affects the features available for use. The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source.

A server built with icc has these characteristics:. The next several sections cover the installation of MySQL on platforms where we offer packages using the native packaging format of the respective platform.

This is also known as performing a binary installation. However, binary distributions of MySQL are available for many other platforms as well. Only bit and bit versions of Windows and later are supported. Otherwise, you may encounter problems with certain operations such as editing the PATH environment variable or accessing the Service Control Manager.

Enough space on the hard drive to unpack, install, and create the databases in accordance with your requirements generally a minimum of megabytes is recommended. Binary distributions are available that contain a setup program that installs everything you need so that you can start the server immediately.

Another binary distribution format contains an archive that you simply unpack in the installation location and then configure yourself. For details, see Section 2. The source distribution contains all the code and support files for building the executables using the Visual Studio compiler system. Generally speaking, you should use a binary distribution that includes an installer. It is simpler to use than the others, and you need no additional tools to get MySQL up and running.

This is because of the fingerprinting mechanism used by the virus scanning software, and the way in which MySQL rapidly updates different files, which may be identified as a potential security risk. There is usually a system built into the virus scanning software to permit certain directories to be specifically ignored during virus scanning.

To prevent the temporary files also being scanned, you should configure a separate temporary directory for MySQL temporary files and add this to the virus scanning exclusion list.

To do this, add a configuration option for the tmpdir parameter to your my. For more information, see Section 2. To use an installation package that does not include an installer, follow the procedure described in Section 2. To install using a source distribution, see Section 2. The Essentials package. This package has a file name similar to mysql-essential This package does not include optional components such as the embedded server and benchmark suite.

The Complete package. This package has a file name similar to mysql This package includes optional components such as the embedded server and benchmark suite. The no-install archive. This package has a file name similar to mysql-noinstall This package does not include an automated installer, and must be manually installed and configured.

The Essentials package is recommended for most users. It is provided as an. The Complete and Noinstall distributions are packaged as Zip archives. To use them, you must have a tool that can unpack. Your choice of install package affects the installation process you must follow. If you choose to install either the Essentials or Complete install packages, see Section 2.

They are recommended for most standard MySQL installations. Exceptions include users who need to install multiple instances of MySQL on a single server host and advanced users who want complete control of server configuration.

The MySQL Installation Wizard makes use of this technology to provide a smoother and more flexible installation process. The Microsoft Windows Installer Engine was updated with the release of Windows XP; those using a previous version of Windows can reference this Microsoft Knowledge Base article for information on upgrading to the latest version of the Windows Installer Engine.

We have switched to WiX because it is an Open Source project and it enables us to handle the complete Windows installation process in a flexible manner using scripts. If you find that the MySQL Installation Wizard is lacking some feature important to you, or if you discover a bug, please report it in our bugs database using the instructions given in Section 1. If the package you download is contained within a Zip archive, you need to extract the archive first.

If you are installing on Windows Vista it is best to open a network port for MySQL to use before beginning the installation. To do this, first ensure that you are logged in as an Administrator, then go to the Control Panel and double-click the Windows Firewall icon. Choose the Allow a program through Windows Firewall option and click the Add port button. Also ensure that the TCP protocol radio button is selected. Confirm your choices by clicking the OK button.

If you do not open a port prior to installation, you cannot configure the MySQL server immediately after installation. The process for starting the wizard depends on the contents of the installation package you download. If there is a setup. If there is an. There are three installation types available: Typical , Complete , and Custom. The Typical installation type installs the MySQL server, the mysql command-line client, and the command-line utilities.

The command-line clients and utilities include mysqldump , myisamchk , and several other tools to help you manage the MySQL server. The Complete installation type installs all components included in the installation package. The full installation package includes components such as the embedded server library, the benchmark suite, support scripts, and documentation. The Custom installation type gives you complete control over which packages you wish to install and the installation path that is used.

If you choose the Typical or Complete installation types and click the Next button, you advance to the confirmation screen to verify your choices and begin the installation. If you choose the Custom installation type and click the Next button, you advance to the custom installation dialog, described in Section 2. If you wish to change the installation path or the specific components that are installed by the MySQL Installation Wizard, choose the Custom installation type.

A tree view on the left side of the custom install dialog lists all available components. Components that are not installed have a red X icon; components that are installed have a gray icon. To change whether a component is installed, click that component's icon and choose a new option from the drop-down list that appears. You can change the default installation path by clicking the Change After choosing your installation components and installation path, click the Next button to advance to the confirmation dialog.

Once you choose an installation type and optionally choose your installation components, you advance to the confirmation dialog.

Your installation type and installation path are displayed for you to review. To change your settings, click the Back button. Registration gives you access to post in the MySQL forums at forums. The final screen of the installer provides a summary of the installation and gives you the option to launch the MySQL Configuration Wizard, which you can use to create a configuration file, install the MySQL service, and configure security settings.

Once you click the Install button, the MySQL Installation Wizard begins the installation process and makes certain changes to your system which are described in the sections that follow.

It contains two string values, Location and Version. The Location string contains the path to the installation directory.

The Version string contains the release number. These registry keys are used to help external tools identify the installed location of the MySQL server, preventing a complete scan of the hard-disk to determine the installation path of the MySQL server. The registry keys are not required to run the server, and if you install MySQL using the noinstall Zip archive, the registry keys are not created. For example, if you install MySQL 5. The following entries are created within the new Start menu section:.

The shortcut prompts for a root user password when you connect. Use this shortcut to configure a newly installed server, or to reconfigure an existing server. This option is not available when the MySQL server is installed using the Essentials installation package. A typical MySQL installation on a developer machine might look like this:.

This approach makes it easier to manage and maintain all MySQL applications installed on a particular system. That means you do not need to remove a previous installation manually before installing a new release. The installer automatically shuts down and removes the previous MySQL service before installing the new version.

Automatic upgrades are available only when upgrading between installations that have the same major and minor version numbers. For example, you can upgrade automatically from MySQL 5. It creates a custom MySQL configuration file my. However, you must open a port in the Windows Firewall. To do this see the instructions given in Section 2. One or the other option is sufficient—you need not do both.

This helps associate configuration files with particular server instances. To ensure that the MySQL server knows where to look for the my. The --defaults-file option instructs the MySQL server to read the specified file for configuration options when it starts.

Apart from making changes to the my. For more information about server configuration, see Section 5. MySQL clients and utilities such as the mysql and mysqldump command-line clients are not able to locate the my.

To configure the client and utility applications, create a new my. If the MySQL Server Instance 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 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.

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. 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. There are three different server types available to choose from. The server type that you choose affects the decisions that the MySQL Server Instance Configuration Wizard makes with regard to memory, disk, and processor usage.

Developer Machine : Choose this option for a typical desktop workstation where MySQL is intended only for personal use. It is assumed that many other desktop applications are running. The MySQL server is configured to use minimal system resources. The MySQL server is configured to use a moderate portion of the system resources. It is assumed that no other applications are running. The MySQL server is configured to use all available system resources.

By selecting one of the preconfigured configurations, the values and settings of various options in your my. The default values and options as described in the reference manual may therefore be different to the options and values that were created during the execution of the configuration wizard. The Database Usage dialog enables 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.

This option is recommended for users who use both storage engines on a regular basis. This option is recommended for users who do not use InnoDB. The Configuration Wizard uses a template to generate the server configuration file. The Database Usage dialog sets one of the following option strings:. When these options are processed through the default template my-template. The remaining resources are allocated to InnoDB. 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 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 enables 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. The maximum number of connections is set at , with an average of 20 concurrent connections assumed. The maximum number of connections is set at Manual Setting : Choose this option to set the maximum number of concurrent connections to the server manually.

Choose the number of concurrent connections from the drop-down box provided, or enter the maximum number of connections into the drop-down box if the number you desire is not listed. Port 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. Enabling strict mode default makes MySQL behave more like other database management systems. For more information about strict mode, see Section 5.

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.

Standard Character Set : Choose this option if you want to use latin1 as the default server character set. Best Support For Multilingualism : Choose this option if you want to use utf8 as the default server character set. This is a Unicode character set that can store characters from many different languages.

Choose the desired character set from the provided drop-down list. 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. 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. If you are installing multiple versions of MySQL onto the same machine, you must choose a different service name for each version that you install.

If you do not choose a different service for each installed version then the service manager information will be inconsistent and this will cause problems when you try to uninstall a previous version. Typically, when installing multiple versions you create a service name based on the version information. For example, you might install MySQL 5. 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 permit root logins from across the network, check the box next to the Enable root access from remote machines option.

This decreases 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. To start the configuration process, click the Execute button. To return to a previous dialog, click the Back button. After you click the Execute button, the MySQL Server Instance Configuration Wizard performs a series of tasks and displays the progress onscreen as the tasks are performed. This template is named my-template. 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.

Users who are installing from the Noinstall package can use the instructions in this section to manually install MySQL. If you are upgrading from a previous version please refer to Section 2.

Make sure that you are logged in as a user with administrator privileges. Choose an installation location. Extract the install archive to the chosen installation location using your preferred Zip archive tool.

Some tools may extract the archive to a folder within your chosen installation location. If this occurs, you can move the contents of the subfolder into the chosen installation location. If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option file.

For options that are used every time the server starts, you may find it most convenient to use an option file to specify your MySQL configuration.

This is particularly true under the following circumstances:. MySQL looks for options in each location first in the my. However, to avoid confusion, it is best if you use only one file. If your PC uses a boot loader where C: is not the boot drive, your only option is to use the my. Whichever option file you use, it must be a plain text file. You can also make use of the example option files included with your MySQL distribution; see Section 4.

An option file can be created and modified with any text editor, such as Notepad. Note that Windows path names are specified in option files using forward slashes rather than backslashes. If you do use backslashes, double them:. The rules for use of backslash in option file values are given in Section 4. If you would like to use a data directory in a different location, you should copy the entire contents of the data directory to the new location.

Use a --datadir option to specify the new data directory location each time you start the server. All of the preceding binaries are optimized for modern Intel processors, but should work on any Intel iclass or higher processor. Each of the servers in a distribution support the same set of storage engines.

MySQL servers on Windows support named pipes as indicated in the following list. Named pipes are enabled only if you start the server with the --enable-named-pipe option. It is necessary to use this option explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used. Named-pipe connections are permitted only by the mysqld-nt and mysqld-debug servers. Most of the examples in this manual use mysqld as the server name.

If you choose to use a different server, such as mysqld-nt , make the appropriate substitutions in the commands that are shown in the examples. This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command line or as a Windows service. Adjust the path names shown in the examples if you have MySQL installed in a different location.

Clients have two options. MySQL for Windows also supports shared-memory connections if the server is started with the --shared-memory option.

For information about which server binary to run, see Section 2. In this way you can have the server display status messages in the window where they are easy to see. If something is wrong with your configuration, these messages make it easier for you to identify and fix any problems. For a server that includes InnoDB support, you should see the messages similar to those following as it starts the path names and sizes may differ :. When the server finishes its startup sequence, you should see something like this, which indicates that the server is ready to service client connections:.

The server continues to write to the console any further diagnostic output it produces. You can open a new console window in which to run client programs. The error log is the file with the. The accounts that are listed in the MySQL grant tables initially have no passwords. After starting the server, you should set up passwords for them using the instructions in Section 2. The MySQL server can be started manually from the command line. This can be done on any version of Windows.

The path to mysqld may vary depending on the install location of MySQL on your system. If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply the password when prompted. This command invokes the MySQL administrative utility mysqladmin to connect to the server and tell it to shut down.

If mysqld doesn't start, check the error log to see whether the server wrote any messages there to indicate the cause of the problem. It is the file with a suffix of. You can also try to start the server as mysqld --console ; in this case, you may get some useful information on the screen that may help solve the problem. The last option is to start mysqld with the --standalone and --debug options. Use mysqld --verbose --help to display all the options that mysqld supports. On the Windows desktop, right-click the My Computer icon, and select Properties.

Next select the Advanced tab from the System Properties menu that appears, and click the Environment Variables button. Under System Variables , select Path , and then click the Edit button. The Edit System Variable dialogue should appear. Place your cursor at the end of the text appearing in the space marked Variable Value.

Use the End key to ensure that your cursor is positioned at the very end of the text in this space. There must be a semicolon separating this path from any values present in this field. Dismiss this dialogue, and each dialogue in turn, by clicking OK until all of the dialogues that were opened have been dismissed. You should now be able to invoke any MySQL executable program by typing its name at the DOS prompt from any directory on the system, without having to supply the path.

This includes the servers, the mysql client, and all MySQL command-line utilities such as mysqladmin and mysqldump. You must exercise great care when editing your system PATH by hand; accidental deletion or modification of any portion of the existing PATH value can leave you with a malfunctioning or even unusable system. Generally, to install MySQL as a Windows service you should be logged in using an account that has administrator rights.

To avoid conflicts, it is advisable to close the Services utility while performing server installation or removal operations from the command line. Before installing MySQL as a Windows service, you should first stop the current server if it is running by using the following command:.

The service-installation command does not start the server. Instructions for that are given later in this section.

The following additional arguments can be used in MySQL 5. You can specify a service name immediately following the --install option.

The default service name is MySQL. If a service name is given, it can be followed by a single option. The use of a single option other than --defaults-file is possible but discouraged.

Also, in MySQL 5. As of MySQL 5. This causes the server to run using the LocalService Windows account that has limited system privileges. This account is available only for Windows XP or newer. If both --defaults-file and --local-service are given following the service name, they can be in any order. For a MySQL server that is installed as a Windows service, the following rules determine the service name and option files that the server uses:.

If the service-installation command specifies no service name or the default service name MySQL following the --install option, the server uses the a service name of MySQL and reads options from the [mysqld] group in the standard option files. If the service-installation command specifies a service name other than MySQL following the --install option, the server uses that service name.

It reads options from the [mysqld] group and the group that has the same name as the service in the standard option files. This enables you to use the [mysqld] group for options that should be used by all MySQL services, and an option group with the service name for use by the server installed with that service name.

If the service-installation command specifies a --defaults-file option after the service name, the server reads options only from the [mysqld] group of the named file and ignores the standard option files.

Here, the default service name MySQL is given after the --install option. If no --defaults-file option had been given, this command would have the effect of causing the server to read the [mysqld] group from the standard option files. However, because the --defaults-file option is present, the server reads options from the [mysqld] option group, and only from the named file. Once a MySQL server has been installed as a service, Windows starts the service automatically whenever Windows starts.

The NET command is not case sensitive. When run as a service, mysqld has no access to a console window, so no messages can be seen there. If mysqld does not start, check the error log to see whether the server wrote any messages there to indicate the cause of the problem. When a MySQL server has been installed as a service, and the service is running, Windows stops the service automatically when Windows shuts down. You also have the choice of installing the server as a manual service if you do not wish for the service to be started automatically during the boot process.

To do this, use the --install-manual option rather than the --install option:. Then use the --remove option to remove it:. If mysqld is not running as a service, you can start it from the command line. For instructions, see Section 2. Please see Section 2. You can test whether the MySQL server is working by executing any of the following commands:.

In this case, start mysqld with the --skip-name-resolve option and use only localhost and IP numbers in the Host column of the MySQL grant tables.

Use the --socket option to specify the name of the pipe if you do not want to use the default pipe name. Note that if you have set a password for the root account, deleted the anonymous account, or created a new user account, then you must use the appropriate -u and -p options with the commands shown above to connect with the MySQL Server.

See Section 4. For more information about mysqlshow , see Section 4. The purpose of this section is to help you diagnose and correct some of these errors.

Your first resource when troubleshooting server issues is the error log. The MySQL server uses the error log to record information relevant to the error that prevents the server from starting. The error log is located in the data directory specified in your my. MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.

Please report any bugs or inconsistencies you observe to our Bugs Database. Thank you for your support! We suggest that you use the MD5 checksums and GnuPG signatures to verify the integrity of the packages you download.

Skip navigation links. Developer Zone Downloads Documentation.