FREE MySQL Tutorial, Connecting MySQL Server database, Connect Command

Topic

How to connect MySQL server?
Connecting MySQL Database.

Explanation

Connecting MySQL server :

There are three ways to connect to a 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 Files\MySQL\MySQL Server 4.1\bin"

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

C:\Program Files\MySQL\MySQL Server 4.1\bin> 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 a 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.

External MySQL Tools :

    You can also get connected to MySQL, using external tool like MySQL Query Browser.