MySQL - HELP ME PLEASE - Asked By Kevin on 16-May-11 11:48 PM

hello sir,

hi im kevin and i'm just here asking for some help of how install SQL on my computer windows 7 (home premium) it had been hard doing it for me my friend...

I REALLY NEED YOUR HELP WITH THAT

please i need ur help...reply me  please..................THANK YOU
Riley K replied to Kevin on 16-May-11 11:54 PM

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.

Ravi S replied to Kevin on 17-May-11 12:00 AM
HI

Make sure that you install it before Visual Studio, and also make sure you enable these Windows features first:

Common HTTP Features

  • Static Content
  • Default Document
  • HTTP Redirection
  • Directory Browsing

Application Development

  • ASP.Net
  • ISAPI Extension
  • ISAPI Filters

Security

  • Windows Authentication

IIS6

  • IIS 6 WMI
  • IIS Metabase

Then install SP2 at least, but preferably SP3



refer the links also
http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/6f34833e-b72d-41c2-8bca-e8589ad2218c
http://blogs.msdn.com/b/sqlreleaseservices/archive/2009/10/23/sql-server-on-windows-7-and-windows-server-2008-r2.aspx
Jitendra Faye replied to Kevin on 17-May-11 12:04 AM
Follow this link-

http://webdevcodex.com/tutorial-installing-apache2-php5-mysql5-phpmyadmin3-windows-7-vista/

here you will get steps for installing mysql.