Instructions to install MySQL and MySQL Connector/J

Instructions to install MySQL and MySQL Connector J

The CD that accompanies this book includes MySQL 4.0.20an open-source database management system. MySQL executes on many platforms, including Windows, Solaris, Linux, and Macintosh. Complete information about MySQL is available from

www.mysql.com/products/mysql/

To install MySQL:

1. Insert the CD into the CD drive (the D: drive on our system), and change directories to D:softwareMySQLmysql-4.0.20c-win.
2. Double click SETUP.EXE to start the MySQL installer. Follow the instructions to install MySQL in the C:mysql directory, which is the default directory.

Instructions for installing MySQL can also be found in Chapter 2 of the MySQL Manual at dev.mysql.com/doc/mysql/en/index.html.

To use MySQL with JDBC, you also need to install MySQL Connector/Ja JDBC driver that allows programs to access MySQL databases via JDBC. MySQL Connector/J is on the CD that accompanies this book and can also be downloaded from

www.mysql.com/products/connector/j/

At the time of this writing, the current stable release of MySQL Connector/J is 3.0.14. To install MySQL Connector/J:

1. Copy mysql-connector-java-3.0.14-production.zip to your hard disk.
2. Open mysql-connector-java-3.0.14-production.zip with a file extractor, such as WinZip, which can be downloaded from www.winzip.com. Extract its content to the C: drive. This will create a directory named mysql-connector-java-3.0.14-production. The documentation for MySQL Connector/J is in connector-j-en.pdf in the docs subdirectory of mysql-connector-java-3.0.14-production, or you can view it online at dev.mysql.com/doc/connector/j/en/index.html.