GNU Info

(mysql.info)Windows installation

---

Prev: Linux-RPM Up: Quick Standard Installation

---

Enter node , (file) or (file)node

Installing MySQL on Windows
---------------------------

The following instructions apply to precompiled binary distributions.
If you download a source distribution, you will have to compile and
install it yourself.

If you don't have a copy of the MySQL distribution, you should first
download one from `http://www.mysql.com/downloads/mysql-3.23.html'.

If you plan to connect to MySQL from some other program, you will
probably also need the *MyODBC* driver. You can find this at the
*MyODBC* download page
(`http://www.mysql.com/downloads/api-myodbc.html').

To install either distribution, unzip it in some empty directory and
run the `Setup.exe' program.

By default, MySQL-Windows is configured to be installed in `C:\mysql'.
If you want to install MySQL elsewhere, install it in `C:\mysql' first,
then move the installation to where you want it.  If you do move MySQL,
you must indicate where everything is located by supplying a
`--basedir' option when you start the server.  For example, if you have
moved the MySQL distribution to `D:\programs\mysql', you must start
`mysqld' like this:

     C:\> D:\programs\mysql\bin\mysqld --basedir D:\programs\mysql

Use `mysqld --help' to display all the options that `mysqld'
understands!

With all newer MySQL versions, you can also create a `C:\my.cnf' file
that holds any default options for the MySQL server.  Copy the file
`\mysql\my-xxxxx.cnf' to `C:\my.cnf' and edit it to suit your setup.
Note that you should specify all paths with `/' instead of `\'. If you
use `\', you need to specify it twice, because `\' is the escape
character in MySQL.  Note: Option files.

Starting with MySQL 3.23.38, the Windows distribution includes both the
normal and the *MySQL-Max* binaries.  The main benefit of using the
normal `mysqld.exe' binary is that it's a little faster and uses less
resources.

Here is a list of the different MySQL servers you can use:

`mysqld'            Compiled with full debugging and automatic memory
                   allocation checking, symbolic links, BDB and InnoDB
                   tables.
`mysqld-opt'        Optimized binary with no support for transactional
                   tables.
`mysqld-nt'         Optimized binary for NT with support for named
                   pipes. You can run this version on Win98, but in this
                   case no named pipes are created and you must have
                   TCP/IP installed.
`mysqld-max'        Optimized binary with support for symbolic links,
                   BDB and InnoDB tables.
`mysqld-max-nt'     Like `mysqld-max', but compiled with support for
                   named pipes.

Starting from 3.23.50, named pipes are only enabled if mysqld is
started with `--enable-named-pipe'.

All of the above binaries are optimized for the Pentium Pro processor
but should work on any Intel processor >= i386.

NOTE: If you want to use InnoDB tables, there are certain startup
options that must be specified in your `my.ini' file! Note: InnoDB
start.