- Stable, reliable, fastest web server ever.
- MySQL Enterprise Installation.
- Installing MySQL Community Server.
- Installing MySQL on Windows.
First download Mysql Server database from Mysql download link their own offical site
Pick your choice operating system and download according your hardware.
In linux, it would be RPM, and for windows it would be zip, exe or msi file.
We are using Windows downloads (platform notes) Windows ZIP/Setup.EXE (x86)5.0.45 version.
Steps of installing mysql Server
Steps to configure mysql Server automatic. You need to follow the next screen and read it carefully as shown all screen step by step here.
Mysql tool help us to write query and administrator database easily. This gives us GUI interface for edit, delete, Update, and delete from database. Instead of mysql tools we have to use command prompt to edit any thing. We recommend that to use query browser instead of command prompt. Use mysql tools, you need to install it. Download mysql-gui-tools-5.0-r12-win32.msi from mysql official website
Steps to install mysql tools
After installation Mysql tools, we can create database in Mysql. In database, database is known as schema. We need to create first schema before making tables in database. Database is almirah, where all file and table kept. Tables is a folder where all records keep.
Steps to make schema in mysql
Start first query browser from start menu of mysql.
Server host should be localhost and username should be root if you have not set user at time of installation of mysql server
Right click on the top right side
Choose mysql schema to create
Give schema name according to your requirement
Schema is created successfully. Check it by refreshing on right side by right click
Final steps to create tables in mysql database
select create mysql tables
Enter field name and table name with data type. What datatypes should be assign to field. e.g salary cannot be string. so datatype should be integer. Name should be varchar String not integer.
Excute to create table
Now table has been created
View data from table need to execute query with select command.
Select * from tableName
Inserting data in mysql table need to edit in bottom. First press edit and then enter data in row shown in green row. After inserting data you need to apply change. Again execute select query in query browser.