Install MySQL on Windows 7

 

Introduction

 

Download MySQL

 

Uninstall any previous versions through Control Panel prior to install.

 

MySQL is 'Open Source' software that is undergoing constant development.

 

At the time of writing this guide there are two later versions available

1. MySQL 5.5 is the current development release series

2. MySQL 5.1 is the current General Availability (Production) release series

 

I recommend you dowload the latest General Availability (GA) version as it has undergone extensive testing and is considered 'stable'.

To check which is the latest GA version click here - http://dev.mysql.com/doc/refman/5.1/en/choosing-version.html

 

The download you need for Windows is 'MSI Installer' for your system

mysql-essential-X.XX.XX-win32.msi - for 32 bit Windows OR

mysql-essential-X.XX.XX-winx64.msi - for 64 bit Windows

 

Download link - http://dev.mysql.com/downloads/mysql/#downloads

 

You must exit all other programs, in particular Anti Virus programs.

 

The install outlines here was on a 64bit system and is identical to 32 bit install.

 

Should you experience errors with the install - see NOTES below

 

Step 1

Navigate to the folder you downloaded to and click on install package.

 

 

 

Step 2

You may receive this security warning - click Run

 

 

Step 3

Click Next >

 

 

Step 4

You may select Typical if you are have a limited hard disk capacity.

I recommend Complete install.

Click Next >

 

 

Step 5

You are now ready to install - click Install

 

 

Step 6

Click Next >

 

 

Step 7

Click Next >

 

 

Step 8

Tick Configure the MySQL Server now

Registration is optional.

Click Finish

 

 

Step 9

Click Next >

 

 

Step 10

Your will only see this screen if you have previously installed or patrially installed this version of MySQL

If not previously installed go to Step 11

Select Reconfigure Instance then click Next >

 

 

Step 11

Select Detailed Configuration then click Next >

 

 

Step 12

Select Developer Machine then click Next >

 

 

Step 13

Select Non-Transactional Database Only then click Next >

 

 

Step 14

Select Decision Support (DSS)/OLAP then click Next >

 

 

Step 15

Select both (default) options: Enable TCP/IP Networking and Enable Strict Mode then click Next >

 

 

Step 16

Select (Default) Standard Character Set then click Next >

 

 

Step 17

Select both options: Install As Windows Service and Include Bin Directory in Windows Path then click Next >

 

Note: if you have installed an earlier version of MySQL the default Service Name: MySQL will not be available as it is already in use.

You MUST uninstall previous version to use the default Service Name

 

 

Step 18

If you have a previous install you must enter Current root password - if no previous install you will not see this

Enter New root password and Confirm

Make sure you record the Root Password

Note: The default username is root.

It is recommended to change this setting up PHPMyAdmin or MySQL Command Line Client (advanced)

Click Next >

 

 

Step 19

Click Execute to configure your database server.

 

 

NOTES

Should you receive any error messages when installing then cancel the install

Go to 'Control Panel' and remove MySQL

Before reinstalling shut down & restart then close all programs, including Anti Virus and reinstall.

If problem persists, more likely with 64 bit install, try downloading the current development release and installing.

Help can also be found at http://www.mysql.com/

 

NOTE: This drove me nuts for a while creating all sorts of errors in php code I was using

For some reason Microsoft thought we all required Military grade security and enabled 'Strict Mode' by default in MySQL.

This would only be required by securty & government agencies, eg my ISP disable on their server.

You can surf around on Google to read up on it & the various complex methods to disable it or keep reading.

 

To disable Strict Mode the easy way

Open your my.ini file

located at C:\Program Files\MySQL\MySQL Server 5.5\my.ini in your text editor (eg notepad)

Use control F (push Ctrl & F keys on keyboard together) and search for 'Strict'

locate this

 

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

 

Change to this

 

# Set the SQL mode to strict
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

 

or you can delete these lines altogether

 

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

 

by placing the hash (#) in front it disables Strict Mode

 

I recommend the (#) method so the lines are still there if you ever need enable 'Strict Mode' again (if you become a high security programmer!)

 

Then simply save the file in it's original location (eg click File then 'Save').

 

Mission Complete!!!

 

 

 

 

The next logical step is to install phpMyAdmin as a graphical front end - see link below.

 

Related Articles

 

Change Control Panel View on Windows 7

 

Disable User Account Control (UAC) on Windows 7

 

Install and Configure IIS 7.5 & PHP & FastCGI on Windows 7

 

Windows_7_Install_mcrypt_extension_and_libmcrypt_dll_for_PHP

 

Install PHPMyAdmin on IIS 7.5 on Windows 7