From Appendix B of Kroenke’s book:

http://dev.mysql.com/downloads/mysql/

Community Server 5.5.22  - Win 32 bit MSI installer

Mysql-5.5.22.zip (Win X86, 32-bit) 27.8 MB

MySql Workbench – Windows 32 – MSI installer

Got md5.exe from cnet and installed in program Files

Install community server – double click .msi

Setup wizard Splash screen

Next

Accept GPL

Next

Complete (not the default)

MySQL Enterprize splash screen

Next

Next

Finish – lauches Configuration Wizard 1.0.17.0

Next

Detailed config

Next

Developer Machine

Next

Transactional DB only (not the default)

Next

InnoDB tablespace settings

Next

Decision Support (DSS)/OLAP 

Next

Enable TCP/IP, port 3306, no firewall exception, strict mode

Next

Standard character set

Next

Install as service MySQL, lauch automatically, include bin dir in windows path (including in path is not default)

Next

Password

root

root

(no root access from remote machines)

Next

Execute

Finish

mysqld.exe now in process list

Install mysql workbench

Double click MSI

Next

Next

Complete

Next

Install

Finish  (lauches mysql workbench, which takes a while)

Double click Local Instance MySQL

root   (to connect to the local server)

(test database appears)

Double click ‘test’ schema

Click add table icon

Engine==InnoDB

idDemo added automatically

check AI box (auto-increment)

add ‘descr’ column (VARCHAR(45) default)

Apply (note mysql workbench writes the SQL for you)

Apply (executes the script)

Show logs button – Script successfully applied

Finish

In PetStore00.accdb, exported Animal table to excel

In excel:

Fixed date format to yyyy-mm-dd

Fixed price to decimal

Removed photo

Export as csv

In MSworkbench:

After creating table, Use Load statement to populate