Installing MySQL on Windows

Last updated November 20, 2009. Created by Kjartan on August 24, 2001.
Edited by Persiatis, DyanneNova, puregin, kika. Log in to edit this page.

After downloading the latest stable release version of MySQL, locate the setup.exe, and execute it. When prompted choose custom install.
Choose a path to install it. I recommend keeping to the default, which is c:\mysql.
Select all components, and continue until done.
Go to the MySQL folder, and start winmysqladmin.exe
Choose a username and password for yourself.
In the console, click on the my.ini tab, and choose "create shortcut in startmenu" option.
In the my.ini tab, also check that all the configurable options are correct in accordance to your computer.
Close the admin console and restart it. If admin program runs with a green light, everything fine.

If you'd like to do an Apache, PHP and MySQL install on XP or Vista you can also download XAMMP from http://www.apachefriends.org for a quick full install.

Comments

On mysql.com, there is three

Posted by agrawalyogesh on June 18, 2008 at 4:44pm

On mysql.com, there are three types of installation for windows

Windows Essentials (x86) 5.0.51b 22.7M Pick a mirror

Windows ZIP/Setup.EXE (x86) 5.0.51b 44.3M Pick a mirror

Without installer (unzip in C:\) 5.0.51b 55.8M Pick a mirror

I tried all of them, but I don't see winmysqladmin.exe on c:\mysql folder at all. am I missing something

I can not find the file

Posted by wolf.alex9 on July 6, 2008 at 11:42pm

I can not find the file either.

silent removed

Posted by bertboerland on September 6, 2008 at 2:18pm

Not many drupalaers use windows so bear in mind that there will be less support (eyeballshttp://forums.mysql.com/read.php?35,18981,18981#msg-18981

However, at http://forums.mysql.com/read.php?35,18981,28509#msg-28509 you can download the program. Since that thread is 3 years old, I am sure there is a better way of installing MySQL / Drupal on windows.

--
groets
bert boerland

XAMPP

Posted by Fleshgrinder on December 8, 2008 at 11:21pm

The easiest way to get everything (Apache, PHP and MySQL) on a Windows machine (XP and Vista) is to use XAMPP from Apache friends. It's installed in a few minutes and you can start developing right away. Give it a try.

http://www.apachefriends.org/

Kindest regards
Fleshgrinder

wrong word

Posted by iridiumcao on October 29, 2009 at 7:25am

the word "chck" in the 7th item should be "check".

Time flies!