MySql Server Installation
Download the MySQL Server for this link: http://www.mysql.com/downloads/Install MySql server properly…..
Start the Mysql setup open a new window in that Click on the Next button
Select the check box(Accept It). Then Click on the Next button
Open a new window in that window having the Setup type select the 'Complete' Setup option button then click on the Next button
Click on the Install button.
The installation processing going on
Now Click o the Next button.
Click on the Finish button with Select the ‘check box option’ then Finish it.
The MySQL Server Configuration Wizard installation process is open click on theNext
In this below window select the radio button is ‘Detailed Configuration option’ Then click on the Next
Here choose the installation directory. Then click on the Next button.
Here the MySQL Server Run on port Number to give the port Number in field. The port Number comes default.(ex:3306) then click on the Next
Select the Install as Windows Services’Install as Windows Services’ click on the Next
Here give the root password as ‘root'; and confirm Password also ‘root’ Click on the Next
Click on the Execute button. Now MySQL Server Instance Configuration is processing on it takes some time to Config
Processing going on
All Configurations are successfully configured. Click on the Finish .
Then finish-> successfully installed MySql, in your system.
Goto start button and open Mysql cmd promtMysql cmd promt , shown below
Open mysql cmd prompt.. and enter paswd(i.e: root).
If you get any welcome msg, it will successfully installed…in your system.
Download the Sql yog from net. After that install the Database Sql Yog then open the sql yog. Click on the shown place.
Then it will connect with the database.
This is the DataBase window.
Here we can easy to create the database name and easy to build the tables also. Comparing to the command promt. it’s very easy to maintaining the DataBase Whereas by using the Cmd promt here maintaining the Database critical. Query process Execution also critical.