Install and Configure MySQL 5 on Windows

Categories:

Configuring MySQL

With the installation complete you should now be presented with the MySQL Server Instance Configuration Wizard as shown below in figure 6. Click the Next button at the bottom to continue.


figure 6

When asked what configuration type you wish to use, select the Detailed Configuration option and click the Next button at the bottom as shown below in figure 7.

figure 7

The next step is choosing the server type. If you will be using MySQL on a server that is hosting other applications as well I suggest you use the Server Machine option. Once you've made your selection click the Next button to continue as shown below in figure 8.


figure 8

Selecting your database usage is an option you should give some consideration as this determines what database types are enabled. For general purpose I would recommend using the Multifunctional Database option as then both the MyISAM and InnoDB database types are enabled. Once you've made your selection click the Next button at the bottom as shown below in figure 9.


figure 9

If you selected an option in the previous step that enables the InnoDB database engine, then you will be prompted to set a path for use by the InnoDB datafile. Leave this as the default (uses the installation path) unless you require otherwise and click the Next button at the bottom as shown below in figure 10.


figure 10

Comments

Anonymous's picture

MySQL ODBC Connector

Hi Dominic,

I did get the ODBC drivers working although I had to install them in reverse that is version 5.1 first followed by version 3.5 not that I need version 3.5 anymore. Thanks for your help.

Anonymous's picture

This is a great tutorial but

This is a great tutorial but i get the following error on the last step: Service could not be started any idea how to fix this?

Anonymous's picture

im stuck

in the mysql server configuration wizard,if i select the port no as 3306 and then when i click next ,next and then execute it says 'cannot create Windows service for Mysql Error:0'
same error when i select the port no 3307,3308,3309

some body among the lot help me in this...please

Brashquido's picture

Remove instance and try again

Have a look at this blog post and see if the solution posted there helps at all.

----------------
Dominic Ryan
6 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

Install and Configure MySQL 5 on Windows Tutorial

This is very good tutorial. Actually I tried to install MySQL msi package for 10 times but getting some exception thing block my installation. With the help of this guide i could actually installed MySQL in just 10 minutes.
Thanks lot!!!!!!!!!!!!!!

Anonymous's picture

mysql command client line and mysql server 5.1

i have to download and installed mysql command line client and mysql server 5.1

Anonymous's picture

Don't get MySQL Configuration Wizard

Hi,

When I get to the Wizard Completed window the "Configure the MySQL Server now" box is already checked, but when I click "Finish" it doesn't come up.

I've uninstalled and reinstalled and made sure I selected the check box myself, but the results are the same.

Any clues as to why this is happening?

Russ :(

Anonymous's picture

RE: Don't get MySQL Configuration Wizard

Oh! I forgot to mention I'm doing this on Windows 7.

Russ :)

Brashquido's picture

Run it manually

Not sure what would be causing it not to run. Had you tried pressing shift + tab in case it had popped up in the background? In any case you should be able to go to the MySQL program group in your start menu and launch the config wizard manually.

----------------
Dominic Ryan
6 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

to good tutorial....

to good tutorial....