Installing MySQL on Windows

Good, the last time we came up on the installation of Apache on Windows. Today we see how to install MySQL on Windows in the series of articles Installing Apache, MySQL and PHP.

MySQL ... what is it?

We will install the version of Community Server version that is offered free of charge. By the time I wrote this article, the latest stable version was 5.1.1942 sources we get here, we are interested mysql-01.05.1942-win32.msi (104.8 MB)

I got the kit, it will now install.

Step 1 (not appropriate to say that by double click on kits)

Step 2 - choosing the type of installation

We will go on they would choose Typical for all defaults and general. In short, it will install everything you need to have installed a database server running. Complete version will install everything and the Custom option will allow you to choose what and how it will be installed.

Step 3 - review

The installer will present an overview of what is going to run.

Step 4 - the actual installation

Step 5 - creating MySQL.com account (optional)

If you want to register for the MySQL community, now you can. If not, go to the window and get away Next to the next step.

Step 6 - Finish the install

At this time the installation completed successfully, all were copied on to their seats. Now you have two options you can follow:

• Server configuration
• registration server (option will allow you to receive automatic notification in case of update and other wonders.)

We will continue with "Configuring the Server", aka the first tick. Click Finish.

Step 7 - the start configuration

Step 8 - configuration choice

We have two options here:

• Detailed configuration - will allow you to choose and configure various parameters in detail - is more complex version
• Standard configuration - choose this option only if you first install MySQL on your computer - this case

Choose Standard Configuration and give them the next.

Step 9 - operating system options

Two options:

• Install As Windows Service - which means that MySQL will run as a Windows service
  • Service name - name of the service, you can leave the default - MySQL
  • Launch the MySQL Server automatically - will honor the server to start automatically when starting and operating system, which is ok, that we want.
• Include Bin Directory in Windows PATH - this option will allow us to call the command line (prompt), I recommend you check this option, you will surely need it later.

Step 10 - Security settings

At this stage we have the opportunity to create a password for the user runs the service, indicated otherwise, even if you run on your personal computer. So you can fill in your password, then login as root with your_password.

• Enable root access from remote machines - well, here's your choice if you can connect to the server with root privileges, but using another computer - my advice is do not choose this option.

Here you can create an anonymous account, but this could lead to security problems, so there is no option to check that. Go to Next

Step 11 - Completion of configuration and application options previously chosen

Now you can click Finish.

That was it. At this time of the personal computer, a server fully functional database. To convince yourself, like this:

1. opens an instance of command line (Start - Run - cmd for Windows XP or Start - run cmd and search it for Vista or 7)

2. Write to the prompt: mysql-u root-p and hit Enter

You will be asked to enter the password that you mentioned earlier, in configuration.
After you enter the password you have something like

To finish the session, close the window or type exit and press Enter.

And voila, we have MySQL parameters.

If you want to deepen what is MySQL, you have

• Formal documentation
• manufacturer's website

Note: setting up the story was done on a version of Windows 7, but the same thing in the sea, and on XP or Vista. I went into the details of operating systems that are not covered by this article. Basically, if your OS security questions, answer them "yes, I agree that MySQL ... to my operating system"

PS: I assume no liability for any damage caused by improper installation, or with a kit obtained from elsewhere than the official site indicated at the beginning, I do not know or could not go to your personal computer.
Opinions / suggestions / comments are welcome.