MySQL Installation on Windows

This section describes how to download, install and start MySQL server on Windows systems.

MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local Windows system very easily. Here is what I did to download and install MySQL 5.5 Community Server on my Windows system:

1. Go to MySQL download Website at https://dev.mysql.com/downloads/mysql/.

2. Go to "MySQL Community Server 5.5.15" section and click the Download button on the "Windows (x86, 32-bit), ZIP Archive - 5.5.15 - 133.4M" line.

3. Login or register yourself to mysql.com and then select a download mirror site

4. Save the downloaded file, mysql-5.5.15-win32.zip (139,896,749 bytes), to the \temp folder on your hard disk.

5. Unzip mysql-5.5.15-win32.zip, then move the output folder from \temp\mysql-5.5.15-win32 to \local\mysql.

6. Open a command window and run "\local\mysql\bin\mysqld" to start MySQL server:

herong> \local\mysql\bin\mysqld --console
nnnnnn 20:34:46 [Note] Plugin 'FEDERATED' is disabled.
nnnnnn 20:34:46 InnoDB: The InnoDB memory heap is disabled
nnnnnn 20:34:46 InnoDB: Mutexes and rw_locks use Windows interlocked
   functions
nnnnnn 20:34:46 InnoDB: Compressed tables use zlib 1.2.3
nnnnnn 20:34:46 InnoDB: Initializing buffer pool, size = 128.0M
nnnnnn 20:34:46 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
nnnnnn 20:34:46  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
nnnnnn 20:34:47  InnoDB: Log file .\ib_logfile0 did not exist: new to
   be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
nnnnnn 20:34:48  InnoDB: Log file .\ib_logfile1 did not exist: new to
   be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
nnnnnn 20:34:50  InnoDB: Waiting for the background threads to start
nnnnnn 20:34:51 InnoDB: 1.1.8 started; log sequence number 0
nnnnnn 20:34:52 [Note] Event Scheduler: Loaded 0 events
nnnnnn 20:34:52 [Note] mysqld: ready for connections.
Version: '5.5.15'  socket: ''  port: 3306  MySQL Community Server (GPL)

7. Open another command window and run "\local\mysql\bin\mysqladmin" to administrate MySQL server:

herong> local\mysql\bin\mysqladmin ping
mysqld is alive

Congratulations, MySQL 5.5 Community Server is running on the local computer now.

The next step is to add "\local\mysql\bin\" to the environment PATH variable to void typing the path name when invoking MySQL commands.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Installing and Running Java DB - Derby

 Derby (Java DB) JDBC Driver

 Derby (Java DB) JDBC DataSource Objects

 Java DB (Derby) - DML Statements

 Java DB (Derby) - ResultSet Objects of Queries

 Java DB (Derby) - PreparedStatement

MySQL Installation on Windows

 MySQL Installation on macOS

MySQL Installation on Windows

 mysqladmin - MySQL Admin Tool

 mysql - Command Line Tool

 Creating Database and User with MySQL Monitor

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 Oracle Express Edition Installation on Windows

 Oracle JDBC Drivers

 Oracle - Reference Implementation of JdbcRowSet

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

 Microsoft SQL Server Express Edition

 Microsoft JDBC Driver for SQL Server

 Microsoft JDBC Driver - Query Statements and Result Sets

 Microsoft JDBC Driver - DatabaseMetaData Object

 Microsoft JDBC Driver - DDL Statements

 Microsoft JDBC Driver - DML Statements

 SQL Server - PreparedStatement

 SQL Server CLOB (Character Large Object) - TEXT

 SQL Server BLOB (Binary Large Object) - BLOB

 JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

 JDBC-ODBC Bridge Driver - Flat Text Files

 JDBC-ODBC Bridge Driver - MS Access

 JDBC-ODBC Bridge Driver - MS SQL Server

 Summary of JDBC Drivers and Database Servers

 Additional Tutorial Notes to Be Added

 Outdated Tutorials

 References

 Full Version in PDF/EPUB