Installation Instructions

Instructions to install MySQL in Windows:

Downloads for the MySQL Community Server are at http://www.mysql.com/downloads/mysql.

Skip the Sign Up

Download and Run the MSI file (depending on 32 bit or 64 bit)

The MySQL setup wizard opens up. Click on the next button to proceed. (It is recommended to retain the default options)

after choosing appropriate options in the following screens; click on 'INSTALL'

Click FINISH to complete the installation and open MySQL instance configuration window.

Configure the MySQL server instance:

on opening MySQL Server Instance configuration Wizard, click 'NEXT'

Select 'Reconfigure Instance' and click 'Next'

Select 'Detailed Configuration' and click 'Next'

Select 'Developer Machine' and click 'Next'

Select 'Multifunctional Database' and click 'Next'

Select the drive and directory where the InnoDB table space should be placed and click 'Next'( recommended to leave as Default)

Select 'Online Transaction Processing(OLTP)' and click 'Next'

Enable TCP/IP Networking. A default port number '3306' is present. Add firewall exception for the port.

Select 'Standard Character Set' and click 'Next'

Select 'Install As Windows Service' and 'Include Bin Directory in Windows Path(optional) and click 'Next'

Under 'Modify Security Settings' enter a root password and retype it in the box below and click 'Next'

Click 'Execute' and it will install and set up.

Once the MySQL database is installed

Download MySQL Workbench (GUI Tool) from http://www.mysql.com/downloads/workbench/

Download and Run the MSI file (depending on 32 bit or 64 bit)

MySQL Workbench Setup Wizard should open, click 'Next'

Select 'complete Installation' and click 'Next'

Click 'Install'.

After 'Installation' click 'Finish'

Now from start menu on the desktop; go to Programs-MySQL-MySQL Workbench and click on it to open.

For SQL development, You will be asked password which is your root password you entered before.

Installing Oracle 11g on windows:

Note-You may have to create a free account before you can download, and to do that you must sign up for at least one mailing list (you can cancel later)

Files can be downloaded from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Accept license agreement and Download both parts of zip files and unzip them in a single folder.

Click on 'Setup' and the installation should begin.

The setup consists of 8 steps.

Step 1

enter your email address and click 'Next'. No need for security updates.

Step 2

select 'create and configure a database' and click 'Next'

Step 3

Select 'Desktop Class' and click 'Next'

Step 4

Recommended keeping basic configuration, enter Administrative password and confirm it. Click 'Next'

(Note-The installer will check for appropriate complexity of the password, it should be 8 characters long with upper case, lower case and also consist of a numeric)

Step 5

Prerequisites are checked.

Step 6

Summary is produced which is recommended to be saved. Click 'Finish'

Step 7

Installation should begin. (Can take some time to finish)

Step 8

Installation of Oracle Database should be successful.

A new window pops up with the option to manage your password.(change password recommended)

Go to the start menu in desktop and click on oracle-OraDb11g_home1 → Database control

Enter username and password. Connect as 'SYSDBA'

You should LOGIN.

For pictorial installation guide can be found at http://abcdba.com/abcdbaserverinstallguideshowtoinstalloracle11gonwindowsdeskt#example_install