Environment Consistency – MySQL (Windows)

We need to make our life easier by creating consistency for every machine. What this means is every machine you try to use, whether it be yours or your colleagues, the environment will be the same when you sit down to help them with something. This is very important if you’re a Development Manager and you’re trying to help one of your staff.

This is one of several posts in regards to this subject.

I really don’t use MySQL too much.  At work, I have Oracle and Sybase.  But I think I’m going to use it in the example code that I post later.  Because we’ll be using Hibernate, for the most part, it really doesn’t matter.  Hibernate hides the nuances of each type of database from us (for the most part).  Anyway, the real reason has to do with the fact we’ll be installing PHP (which we’ve already done for the Apple Macintosh in an earlier post and we’ll be doing for Windows in a later post).  We’ll also need it for WordPress which we’ll also be addressing in a later post.

Here we’re going to install MySQL for Windows.  We’ve already installed it for the Apple Macintosh in an earlier post.

First off, we need the binary.  We’ll go to the MySQL website to download the 5.1 MySQL version file called “mysql-essential-5.1.41-win32.msi”.  After we’ve gotten the file downloaded double click it and we’ll see this window.

Note: You may have downloaded the 64 bit version of MySQL which is completely fine.

Open File - Security Warning MySQL AB

Click “Run” and you’ll see this window:

MySQL 5.1.41 Installer Welcome Screen

Click “Next >” and you’ll see this window:

MySQL Server 5.1 - Setup Wizard

Click on the “Custom” radio button and click “Next >”.  You will see this window:

MySQL 5.1.41 Installer Welcome Screen (Custom Setup)

There’s no reason not to leave the defaults so click “Next >” and you’ll see this window:

MySQL 5.1.41 Installer Welcome Screen (Custom Setup)

Click “Install” and you’ll see a window similar to the following:

MySQL 5.1.41 Installer (Installing)

Once the software has completed installing you’ll see the following window:

MySQL Enterprise Ad

Click “Next >” here and you’ll see this window:

MySQL Enterprise Monitor Ad

Click “Next >” again and now you’ll see this window:

MySQL Setup Wizard Finished

I deselect the “Register the MySQL Server now” but you can leave it checked.  It’s up to you.  Now click “Finish” and you’ll see this window which is the configuration wizard:

MySQL Server Configuration Instance

Click “Next >” and you’ll see this window:

MySQL Instance Configuration Wizard (Type)

Leave “Detailed Configuration” checked and click “Next >” and you’ll see this window:

MySQL Instance Configuration Wizard (Detailed Configuration)

Leave “Developer Machine” checked and click “Next >” and you’ll see this window:

MySQL Instance Configuration Wizard (Multifunction Database)

Leave “Multifunctional Database” checked and click “Next >” and you’ll see this window:

MySQL Instance Configuration Wizard (InnoDB Database)

I’m leaving the defaults selected on my machine but you may want to put the database on a different disk if you have one.  Click “Next >” and you’ll see this window:

MySQL Instance Configuration Wizard (Connections)

Leave the default of “Decision Support (DSS)/OLAP” selected as we won’t be making a lot of concurrent connections to our machine while we’re developing software.  Click “Next >” and you’ll see this window:

MySQL Instance Configuration Wizard (Network)

You’re probably behind a firewall on a corporate LAN so you should be OK to leave these defaults (the port specifically).  Click “Next >” and you’ll see this window:

MySQL Server Instance Configuration (Character Set)

We may do some multi-lingual development so let’s change this to “Best Support for Multilingualism” and the window will look like this:

MySQL Server Instance Configuration (Character Set)

Click “Next >” and you’ll see a window like this:

MySQL Server Instance Configuration (Windows Service)

We want to keep “Install As Windows Service” checked so that MySQL will start up for us automatically.  And we’re also going to check “Include Bin Directory in Windows PATH”.  The window should look like this:

MySQL Server Instance Configuration (Windows Service)

Click “Next >” and you should see this window:

MySQL Server Instance Configuration (Accounts)

Enter a “New root password:” and “Confirm:”.  We then click “Next >” and will see this window:

MySQL Server Instance Configuration (Ready to Execute)

Click “Execute” and you’ll see a window similar to this:

MySQL Server Instance Configuration (Executing)

When it’s finished, you should see this window:

MySQL Server Instance Configuration (Finished Executing)

Click “Finish”.  Let’s reboot and the system should come up with MySQL started and everything in place.

When that’s done, let’s start up a command window by clicking on “Start” and then “Run” and typing “Cmd”.  You should see a window like this:

Windows Run Window

Click “OK” and you should see a window like this:

Windows CMD Window

Type in the following

mysql -u root -p

and you should see a window like this:

mysql -u root -p

Enter the password that you chose for your root password and you should see a screen like this:

Logged into MySQL

And you’re done!  You’ve now got MySQL installed.