Friday, July 12, 2013

How to Install MYSQL database on Windows xp/7/8/2000/98

MySQL means
The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that require a full-featured database management system often use MySQL.

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

  
You may select Typical if you are have a limited hard disk capacity. I recommend Complete install. Click Next >