Here’s step by step guide for install MySQL server on Windows 7Install MySQL on Windows 7

This  is another topic that I want to explain today. MySQL is common friend of Apache web server and PHP. Combination of those software powered many service and many website all over the world.

Download MySQL Binary

MSI Installer vs ZIP
MSI installer highly recommended for basic user, just click next and next for install and offer shortcut for access and configuring the option.
Zip file suitable for advance user who want to configure anything by themselves.
32 bit vs 64 bit
Check your Windows 7 first. Is it 32 bit or 64 bit. If your Windows 7 has 64 bit support I highly recommend 64 bit version specially if you have memory more than 4 GB. If you only have 1 GB of RAM then I recommend you to pick 32 bit version.


Save to My Document or other place.

Install MySQL on Windows 7

Start installation process by double click installer file.
Welcome to the setup wizard for MySQL Server 5.1
Click Next.

Choose Setup Type
MySQL installer provide 3 type of setup :

1. Typical; recommend for general use.
2. Complete; all program features will be installed.
3. Custom; I prefer this one because I want to specify installation folder

Choose Custom and Click Next.

Change install location to C:\mysql\ by click Change button and enter new path. Click Next when you’re ready.

Ready to install program
Examine current setting produced by wizard. click Install to start the process.

Little advertisement from MySQL click Next.

Click Next.

Click Finish to exit the wizard.
make sure to check “configure the MySQL server now“.

Configure MySQL server on Windows 7

MySQL Server Instance Configuration Wizard will start, it will help us to configure MySQL server in easy way.
Click Next.

Select “Detailed Configuration” and click Next.

Choose “Developer Machine” for server type. It will use minimal amount of memory.
Click Next.

Select “Multifunctional Database” for database usage.
Click Next.

Click Next.

Choose “Decision Support (DSS) / OLAP” and click Next.

Choose “Enable TCP/IP Networking” and “Enable Strict Mode“.
Click Next.

Select default character set “manual” and point to UTF 8.
click Next.

Set Windows Option
Choose “Install as Windows Service” and “Include Bin Directory in Windows PATH“.
Click Next.

Set Security Settings
Enter password twice for root account.
Click Next.

Click Execute to start the wizard work for :

• Prepare configuration
• Write configuration file
• Start service
• Apply security settings

Click Finish.

Testing MySQL Server on Windows 7

Open command prompt

Issue these command to see if the server work as expected (BOLD)

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\LAPTOP>mysql -V
mysql Ver 14.14 Distrib 5.1.52, for Win32 (ia32)
C:\Users\LAPTOP>mysql -uroot -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.52-community MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> SHOW ENGINES\G
*************************** 1. row ***************************
Engine: MyISAM
Support: YES
Comment: Default engine as of MySQL 3.23 with great performance
Transactions: NO
XA: NO
Savepoints: NO
*************************** 2. row ***************************
Engine: CSV
Support: YES
Comment: CSV storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 3. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 4. row ***************************
Engine: BLACKHOLE
Support: YES
Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
XA: NO
Savepoints: NO
*************************** 5. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
Transactions: NULL
XA: NULL
Savepoints: NULL
*************************** 6. row ***************************
Engine: InnoDB
Support: DEFAULT
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 8. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
XA: NO
Savepoints: NO
8 rows in set (0.00 sec)
mysql>

Great. At this stage MySQL Server successfully installed with account root enabled with password. Access available via TCP/IP and optimized for developer setting.
I will cover integration of Apache, PHP and MySQL in other post.
Stay health.