Install
*******

Download
========

Download ``mysql-noinstall-5.0.51a-win32.zip`` from
http://dev.mysql.com/downloads/

Preparation
===========

Vista
-----

If you are installing on Windows Vista it is best to open a port before
beginning the installation:

- To do this first ensure that you are logged in as an administrator.
- 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.
- Enter MySQL into the *Name* text box and 3306 (or the port of your choice)
  into the *Port number* text box.  Also ensure that the TCP protocol radio
  button is selected.
- If you wish, you can also limit access to the MySQL server by choosing the
  *Change scope* button.

**Note**:

- If you do not open a port prior to installation, you cannot configure the
  MySQL server immediately after installation.
- On Windows Vista, I could only get the ``noinstall`` option to work.
  The ``msi`` and ``setup.exe`` options cannot be configured.  I got this
  error:

  ::

    c:\Program Files\MySQL\MySQL Server 5.0>bin\MySQLInstanceConfig.exe
    The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail.

  ...and couldn't find any way to solve it.

Install
=======

Linux
-----

::

  sudo apt-get install mysql-server

Windows
-------

Extract the archive.  I extracted to::

  c:\tools\mysql-5.0.51a-win32\

Run MySQL::

  cd c:\tools\mysql-5.0.51a-win32\
  bin\mysqld.exe --console

**Note**: If you omit the ``--console`` option, the server writes diagnostic
output to the error log in the data directory .  The error log is the file
with the ``.err`` extension.

If you omit the ``---console`` option, you can shutdown using this command::

  bin\mysqladmin" -u root shutdown

Check that MySQL has started successfully.  The console output should finish
a bit like this::

  080131 22:41:18 [Note] bin\mysqld.exe: ready for connections.
  Version: '5.0.51a-community'  socket: ''  port: 3306  MySQL Community Edition (GPL)

Test
====

Once the server is running, you can test it using the command::

  service mysql status
  bin\mysqlshow