2.1.1 Installing MySQL on Windows

The MySQL server for Windows is available in two distribution formats:

• The binary distribution contains a setup program that installs everything you need so that you can start the server immediately.
• The source distribution contains all the code and support files for building the executables using the VC++ 6.0 compiler. See section 2.3.7 Windows Source Distribution.

Generally speaking, you should use the binary distribution. It's simpler, and you need no additional tools to get MySQL up and running.

You will need the following:

• A 32-bit Windows Operating System such as 9x, Me, NT, 2000, or XP. The NT family (Windows NT, 2000, and XP) permits you to run the MySQL server as a service. See section 2.6.1.2 Starting MySQL on Windows NT, 2000, or XP. If you need tables with a size larger than 4 GB, install MySQL on an NTFS or newer filesystem. Don't forget to use MAX_ROWS and AVG_ROW_LENGTH when you create tables. See section 6.5.3 CREATE TABLE Syntax.
• TCP/IP protocol support.
• A copy of the MySQL binary distribution for Windows, which can be downloaded from http://www.mysql.com/downloads/. Note: The distribution files are supplied with a zipped format and we recommend the use of an adequate FTP client with resume feature to avoid corruption of files during the download process.
• A ZIP program to unpack the distribution file.
• Enough space on the hard drive to unpack, install, and create the databases in accordance with your requirements.
• If you plan to connect to the MySQL server via ODBC, you will also need the MyODBC driver. See section 9.2 MySQL ODBC Support.

Subsections

• 2.1.1.1 Installing the Binaries
• 2.1.1.2 Preparing the Windows MySQL Environment
• 2.1.1.3 Starting the Server for the First Time

User Comments

Taking Training using "JSP, Servlets, & MySQL" by
author David Harms

GREAT BOOK if your new to Tomcat, Java and MySQL.


My biggest issue installing MySQL was getting the
JDBC driver mm.mysql-2.0.4-bin.jar downloaded and
installed.

Once I found the driver at
http://www.mysql.com/downloads/api-jdbc.html ,
I did not know where to place the driver.

A quick question to some of our folks already
heavy into java and I installed the file under
Tomcat in \Tomcat\Common\Lib. Suddenly my
examples from the book started working.

Wow!! I have dynamic content from a database on
a web page. Easy.

For an excellent complement to the MySQL docs, that sums up all the steps from start to finish...

For Windows 2000/XP

http://www.devside.net/web/server/win32/mysql-bin

For integrating Apache, PHP, MySQL, SSL, Perl, ...

http://www.devside.net

Add your own comment.