how to install MySQL on windows (8)

MySQL is well known free and open source Robust database . in this guide i will show you how to and where from download MySQL and install it in windows with some other helping apps . so you can easily start with MySQL

1 :  Download MySQL http://dev.mysql.com/downloads/
now you have two option either download all in one package or single community server and other tools separately

if you have good internet connection then go ahead download >> all in one installer

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


or if you have slow internet connection download MySQL community server only and download mysql workbench separately

download MySQL community server  http://dev.mysql.com/downloads/mysql/

download MySQL  workbench ( GUI tool )  http://dev.mysql.com/downloads/workbench/5.2.html

2 : Install MySQL

• install normally 
• after installation finish it will open configuration wizard

make sure you checked that in order to run mysql from command line

if you are installing on local developer machine then don't check enable root access

FINISH now mysql installed and running

 Now open CMD and type

mysql -u root -p 

MySQL command line interface

OR you can download mysql workbench gui and use it for performing all your options

MySQL workbench admin panel