MySQL:Installation

Introduction
MySQL is a database server so is designed to store the data - not provide form based input and output facilities.

While it can be run on many systems, this describes how mySQL can be run on a Windows platform.

To provide a way to administer a Windows application is available EMS SQL Manager for MySQL.

MySQL Community Server

 * Available as a free download from Sun Microsystems (2009a)
 * 2009 July - Windows MSI Installer (x86) version 5.1.36 @ 98MB (you will need to register.. but if you go to the bottom of the form you can continue without)

Installation
Choose standard installation

Hint: Make sure you use a database password you can remember (or find if you forget) as there are no magic ways to find it!!

Errors
Problem: Error 0
 * Chose Detailed Configuration.. ok when chose standard configuration (and left current password blank)
 * According to the documentation this occurs if it thinks (or is) another mySQL version installed.
 * Resolution: Cannot Create Windows..(2009)

Where is the mysql database stored?
If you access the file my.ini in the C:\Program Files\MySQL\MySQL Server 5.1, edit in notepad and look for Path to database root (The following was in my one)



IF Application Data doesn't show in windows explorer you may need to change the Folder Options
 * Use Tools>Folder Options> View
 * Show Hidden Files and Folders
 * (While you are there uncheck "Hide Extensions for known file types" - This is a common way to spot potential viruses trying to sneak into your system.)

MySQL Workbench

 * Sun Microsystems (2009b)
 * 2009 July - Windows installer (x86) version 5.1.16 (13.1MB). Requires the .Net 2.0 framework which is integrated with Windows Vista. Windows XP SP2 users need to download the framework and install it prior to MySQL Workbench.

EMS SQL Manager for MySQL Freeware (EMS SQL Manager Lite for MySQL)

 * A freeware graphical tool for MySQL database administration. It has the minimal required set of tools for those users who are new to MySQL server and need only its basic functionality. Being a light edition, SQL Manager Freeware has certain restrictions: it can handle not more than 5 databases, the maximum size of one database should not exceed 100 MB, and some others.
 * Available as a free download from EMS Database Management Solutions, Inc (2009)
 * 2009 July EMS SQL Manager for MySQL Freeware (full installation package), version 4.5.0.4 (06/19/2009)	41.MB