Start With Mysql

If (Have you installed your Mysql server in your local machine)

Proceed to article named How to start with Mysql

Else

Proceed to my previous blog named Mysql Installation

How to start with Mysql

Approach 1: using command prompt

Go to start menu > All program > Mysql > Mysql Command line client

You will prompted to Mysql command prompt where you can run Your Mysql queries.

Below is screen for Mysql command prompt:

Login with your given Mysql password (which is given at the time of installation) .

You will be prompted to below screen:

Now you can run your Mysql queries. This command screen is nothing but a interacting interface to Mysql server Where we need to give command in order to perform any basic operation (creating database schema, inserting data and retrieving data) .

We have next approach which is easy one to this.

Approach 2: Using Mysql client tool

As in my previous blog (Mysql installation) I have given Mysql client installer URL.

This Mysql client is sqlYOG. As the client is nothing but a GUI tool. we can find many more Mysql client available on net. I find this tool as pretty good.

Below is main screen of the tool

Mysql Installation

Mysql server installation

Just go through link:

http://dev.mysql.com/downloads/mysql/

Here you can find Mysql installer for win 32 and win 64 bit machine.

Keep remember, on way of installation of Mysql server, do select remote access option. It will help you access Mysql server from remote machine.

Mysql client installtion

http://www.webyog.com/en/downloads.php

Mysql client Provides a GUI for interacting to Mysql server residing at local machine or remote machine.