Thursday, April 21, 2016

How to activate Windows 7 & 8 Using CMD


To enter your MAK on Windows 8 and successfully activate, you can complete one of the following steps:

NOTE: You will need the license key given to you when you downloaded Windows 8 from the software page

Command Line option:

Step 1 -  Open administrative level command prompt by typing in cmd on the search tab, right click on the command promt and select Run as administrator.

Step 2 - Type in the following command and hit Enter:
    Example:
    slmgr.vbs /ipk 00000-00000-00000-00000-00000

Step 3 - Click OK on the Installed product key successfully screen.

Step 4 - Reboot the machine and check.


GUI option:

Step 1 - Hit the Windows+R hotkeys to open the Run box and run the following command:

     slui.exe 3

This command will open the following Dialog Box in which you can manually enter your MAK. Enter your MAK in the “Product Key” field, click on the “Activate” button.



That's it...

Monday, April 18, 2016

How to install and Configure MySql Server on Windows system.


MySQL being the world’s most popular open source database, providing great features and being fully supported in Microsoft Windows environment.



Step 1 - Download and install the MySql Server in windows system.


Step 2 - Start the MySql server installation.
 
 
 
 
 

Step 3 - If you have selected the checkbox 'Configure the MySQL Server now' in the last step when installing MySQL 5.1, the configuration wizard should start automatically when you click the Finish button. 

Step 4 - Configuration Type:- Select Detailed Configuration here. If this is the only MySQL server installed on your computer.

Step 5 -  Server Type:- As this MySQL server is running on a development box.

Step 6 - Database Usage:- Depends on the purpose of your development box, you can select either Multifunctional Database or Transactional Database Only. Here I select Multi-functional Database.

Step 7 - InnoDB table space settings:- InnoDB table type is the storage engine for a transnational database. Use the default settings here.

Step 8 - Database engine's concurrent connections option.Here I Selected Decision Support.

    => Online Transaction Processing (OLTP) as it is the most common use of MySQL server.

    => If the MySQL server on your development machine is used for decision support such as data warehousing or data mining, select the first option.

 Step 9 - Networking options:- By default selection we can use. If port 3306 has been used by another instance of MySQL server, you can select port 3307 or a different port. And also need to enable mysql port on firewall.

Step 10 - Default Character Set:- By default, the Standard Character Set is selected.
 
But you may want to select the second option - Best Support For Multilingualism. This allows our database to store text in many different languages.
Step 11 - Install MySQL server as a Windows service.

You might also want to check Include Bin Directory in Windows PATH if you want to operate MySQL from command line.
Step 12 - Set a new password to the root account. Enter the same password to all three boxes.
Don't select the Create An Anonymous Account checkbox. This can lead to an insecure system.
Step 13 - Now everything is ready to execute, click Execute button.
 

That's it...