Create First Database and Tables Using Navicat

In this tutorial we use the visual tool Navicat. So at first you should download and install it. After your installation run this program. Then at first you need to connect navicate with MySQL Server.

Click Connection menu>>MySQL

Fill up Connection Name. This can be any name. We use MySQL here.  Next step is input your MySQL Server password. Then press Test Connection Button. If everything is ok then the next screen will come.

Then Press OK button.  After click on the ok button the connection is created. You should check the Save Password Check Box.

Now double click on your connection. For us – we should click on MySQL which is marked as green.

Now we see that there are four MySQL default databases. To create our new database we should right click on our connection>>New Database

Now fill up the database name. In this case our database name is MyFirstDatabase. Then Press OK Button. Our database is created.

Now we want to create tables in our database.  To Create Tables

Double click on our database >> Tables(right click) >> New Table

In this picture you see that we create three columns. Now we can save this. To understand details please view this video tutorial.

Video Tutorial

MySQL Setup Windows 7 Platform

At first download MySQL and double click on the exe file. Then the following screen will come.

Just click on the next button. Then the following screen will come.

Then accept the terms in the License Agreement and press Next button.

Here we click on the complete button for full installation. Then the following Screen will come.

Then press Install Button to Start MySQL Server Installation. The the following screen will come.

Wait here few seconds and pop up the windows permission screen. Give the permission to install continue. Then the following screen will come.

Press Next Button. Then the following screen will come.

Press Next.

To complete your MySQL Server setup just click on finish. But you need to configure your server. So Select Launch the MySQL Instance Configuration Wizard and press finish button. Then again windows permission is required. So to give the permission click on yes button. After that the following screen will come.

Press Next.

Select Standard Configuration and press Next.

Press Next

Type your New root password and confirm it. If you need to access your server from remote machines then select the Enable root access from remote machines. Then press next.

Press Execute button. Wait here for few minutes. Then all options are executed and Visible the Finish Button. Click Finish to exit set up.