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
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
Navigate to the folder you downloaded to and click on install package.
You may receive this security warning - click Run
Click Next >
You may select Typical if you are have a limited hard disk capacity. I recommend Complete install. Click Next >
You may select Typical if you are have a limited hard disk capacity.
I recommend Complete install.
You are now ready to install - click Install
Tick Configure the MySQL Server now Registration is optional. Click Finish
Tick Configure the MySQL Server now
Registration is optional.
Click Finish
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 >
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 >
Select Detailed Configuration then click Next >
Select Developer Machine then click Next >
Select Non-Transactional Database Only then click Next >
Select Decision Support (DSS)/OLAP then click Next >
Select both (default) options: Enable TCP/IP Networking and Enable Strict Mode then click Next >
Select (Default) Standard Character Set then click Next >
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
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
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 >
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 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
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.
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
Introduction
Step 1
Step 2
Step 3
Step 4
Step 5
Step 6
Step 7
Step 8
Step 9
Step 10
Step 11
Step 12
Step 13
Step 14
Step 15
Step 16
Step 17
Step 18
Step 19
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