Install and Configure MySQL 5 on Windows

Categories:

MySQL Server is one of the most popular database servers in the world, especially for use with dynamic, content rich websites. in fact the website you are looking at now is powered by MySQL. This guide will walk you through all the steps needed to both install and configure your MySQL 5 server on your Windows machine. Make sure you read the steps carefully as they explain why you should and shouldn't enable some options, and if your get stuck you can always get help right here in our forums. Lets get on with the guide...


Installing MySQL

First step is to download the latest MySQL install package from the MySQL site. There are several packages to chose from, but for general usage I recommend you use the Windows Essentials package. Once you have downloaded the installer package double click on it to initilize the installation wizard as shown below in figure 1.


Figure 1

The first step in the installation wizard will be to choose the setup type. Here I recommend using the Custom option so that you can define your installation path. Once you have this selected press the Next button as shown below in figure 2.


figure 2

Use the Change botton in the lower right hand side of this window to specify your installation path, and I generally recommend using a path without spaces. Leave the installtion values as the default and click the Next button as shown below in figure 3.


figure 3

You do not need to have or create a MySQL account to use MySQL, so unless you wish to do otherwise I recommend you select the Skip Sign-Up option and click the Next button as shown below in figure 4.


figure 4

This completes the installation phase of your MySQL server setup. Ensure that the Configure the MySQL Server now option is checked and click the Finish button to complete the installtion wizard and start the configuration wizard.


figure 5

 

Comments

Anonymous's picture

Help Needed

Hi,

The tutorial is really good. Can you please pass me how we can delete a root account from my mysql installation. I have heard that there are two root accounts in any installation and you have to delete one in order to increase security and get rid of unwanted problems.

A help will be greatly admired.

Thanks

Brashquido's picture

That is the first I've heard

That is the first I've heard about there being 2 root accounts. I would very, very, very strongly recommend against deleting your root account and instead look at taking steps to make it more secure. Things such as renaming the account with random characters, ensuring you have a very strong password, changin the default port number and limiting what hosts are able to connect to your root account.
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

reconfiguration

I've installed MySQL 5.0 on my windows and configured it in standard mode, also made the root user without any password. now I want to define a password for my root user, but when I delete the current user and configure mySQL again (according to your advice), it can not make the new user and configuration is failed. Please tell me what can I do?
THANKS

Brashquido's picture

Unless you deleted the root

Unless you deleted the root user then you should be able to follow my guide for creating a MySQL user via the command line.
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

MySQL extension problem

After following the PHP Installaton guide, MySQL installation guide, both are working fine...seperately. But when I try to run any PHP application that requires MySQL, an error meesage occurs wherein it says that it cannot find the MySQL Databse or the required extension file is missing or disabled.

I have installed MySQL on D: drive instead of the traditional C: drive. But I have changed the necessary paths in the php.ini file & also enabled the necessary extensions in it. Also verified if those extensions exist in the /ext folder or not.
But no use.

Please help.

Brashquido's picture

A few questions for you; 1)

A few questions for you;

1) Does the database you are trying to connect to actually exist?
2) What MySQL paths exactly did you update in php.ini?
3) Have you created yourself a simple phpinfo page to verify that the MySQL extension is loading with PHP?
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

cannot start service

while configuring... the message was: cannot start windows service :(

Brashquido's picture

Have a look at your

Have a look at your application event log for MySQL related errors. It should help determine what the problem is.
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Anonymous's picture

Nice tutorial ... but the Configuration doesn't work!

This is a great collection of screenshots ... unfortunately even if you do follow all instructions you have a good chance of failure.
My first aberration from your screenshots occurred in the dialog "MYSQL Server Instance configuration" ... which had an additional old password text field above the 2 fields provided for the root password.
Bottom line: at the end of the wizard when it tries to apply all the config settings I get the dreaded "Access denied for user ''root@localhost" error ... am unable to finish and have to skip the beautiful GUI !!

I have had this same error in 4 or 5 MySQL installs on Windows (up till now all ver. 3 or 4) and the solution is to hack around on a cmd line, creating the service manually and then GRANT priveleges to root@localhost and force a password set ..

I had hoped that the improved GUI in MySQL 5 might solve this problem but no such luck. I find it particularly shoddy of MySQL that after all these years the same problem occurs on what ought to be a simple install operation!!

Thanks for the screenshots ... but in my continuing experience the whole Configuration Wizard GUI is utterly worthless!

Paul

Anonymous's picture

A question....

I m a beginner with mysql.... i just started a .net project. i alredy did as u said in this tutorial. but my problem is , how do configure mysql as to enable remote access...as my project will require a client side software to connect to the database.
and plz can u mail me the answer to

it will nice of u.
plz help.
Mohit