Connecting MySQL Server

How to connect MySQL server?

Explanation

Connecting MySQL server :

There are three ways to connect MySQL server. They are:

Command Prompt

MySQL Command Line Client

External MySQL Tools

Command Prompt :

You can connect MySQL from your Console window i.e., Start -> Run.., type cmd or command to open the Command prompt window.
After opening the console window, enter the path where your MySQL is installed. For example:

C:> "C:Program FilesMySQLMySQL Server 4.1bin"

After giving the path, enter the below command to connect to MySQL server:

C:Program FilesMySQLMySQL Server 4.1bin> mysql.exe -u root

The path may vary depending on the MySQL installation on your system. Instead of root you can also connect by giving your username.

MySQL Command Line Client :

To connect MySQL server using the command line client, go to
Start -> Programs -> MySQL -> MySQL Server 4.1 -> MySQL Command Line Client. The command line client window will be opened and enter the password to start your queries.