We are going to use MySQL database for all “Evejob” versions, except versions for  .NET platform.

So let’s install MySQL Community Edition Server. You can get installation files from http://dev.mysql.com/downloads/mysql/

Be sure that you download 64 bit version for Windows, like Windows MSI Installer (AMD64 / Intel EM64T), from here http://dev.mysql.com/downloads/mysql/5.1.html#winx64 for example.

Installation of MySQL for Windows is simple operation (in contrast to configuration MySQL for production usage), so I will skip installation steps here… We can leave all settings by default – it’s enough for development purposes on local machine.

To manage database you can download GUI Tools from http://dev.mysql.com/downloads/gui-tools/.

Also note that exists A LOT of free / not free and excellent tools to manage / design MySQL databases (for both development and production).

I will list here just some of them:

• MySQL Workbench – “visual database design application that can be used to efficiently design, manage and document database”
• Navicat for MySQL – powerful database administration and development tool (without complex visual design features) available in both commercial and Non-commercial (Free) Lite version
• DevArt dbForge Studio for MySQL – “cutting-edge administration tool and development environment for professional working with MySQL databases” and this is TRUE! Best that I see for MySQL!!! Highly recommended! Sure Express version (that is free) is very limited, so probably after 30 days trial period you will buy Non-Commercial Professional Edition License (cost only 99$) or Commercial for 199$ (more info about versions / prices here)
• SQLyog MySQL – “the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends and MySQL GUI tools in a single intuitive interface” – actually I think this tools make sense to use more during maintenance period than during development and because they are not free I recommend to skip them for now…

After installation of MySQL, you just need to know for development following information (that you setup during installation):

1. Server Host (”localhost” in your case, if you install it on your local machine) and port (default 3306)
2. Username (usually root)
3. Password (you enter it during installation of MySQL or even possible you leave it blank – sure NOT for production!)

Now using this connection parameters, you can run MySQL Administrator (from GUI MySQL Tools) or any administrator utility and check connectivity. If everything OK and you see all 3 schemes (”information_schema”, “mysql” and “test”), you can move forward and start development using MySQL as primary database.