Install MySql Instance in Microsoft Windows 7 with 64 bit

1.Download MySql Installer ( mysql-5.5.9-winx64.msi) From   - http://dev.mysql.com/downloads/mysql/
2.Install MySql. This is Important point don't give default folder Name. Change the name Like MySQL Server5. it should not finish like 5.5
3.On continue to above install my sql Instance. End of installation you need to give username and password. Just remember that.( better to give admin/admin)

 Go to windows command prompt

4. Execute following command ( Login into mysql ):- mysql -u root -p mysql
5. To Create database schema   Execute this :- use mydatabase ( mydatabase is database name )
6. Granting permission to admin for mydatabase schema :- GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'admin' WITH GRANT OPTION;
7. Connect this database from external system by following credentials
Database: mydatabase
URL: jdbc:mysql://localhost:3306/mydatabase
userName: admin
Password: admin


8.Now you are able to create table and persist into it. all the best.


Known Problems:-
1.If you give you default my sql name like *5.5 it will hangup while execute. 
2.After Uninstall windows 7 won't remove service from registry. it may be bug. Here how to remove manually:
go to windows command prompt and enter: regedit and Computer>HKEY_LOCAL_MACHINE>System>CurrentControlSet>Service>MySql.


Find MySql and remove manually.
3.While Uninstall you can remove software data by following:-
windows command prompt and enter: %ALLUSERSPROFILE% and remove MySQL related data.





.